Security/ What system privileges APPS user should have?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Security/ What system privileges APPS user should have?

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Security/ What system privileges APPS user should have?

    What system privileges APPS user should have?

    Hi all,

    Apps 11.5.7, DB 8.1.7.4.11

    I want to know that what roles and system privileges APPS user should have? Currently, at my client site, APPS user has ALTER SYSTEM and ALTER SESSION privs also. Are these requied?

    Can somebody show me the list of system privileges and roles that APPS user should have?

    Thanks in Adv.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    May 2002
    Location
    England
    Posts
    78
    The best advice about the apps user is to leave it as is. I have checked in two of our 11i dbs and both have those two privileges set, so they are obviously required for something, what that would be is anybodys guess, but I would definitely leave it as is.

    just make sure that you change the apps password regularly and don't give it out to freely.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width