Security/ What system privileges APPS user should have?
What system privileges APPS user should have?
Apps 11.5.7, DB 220.127.116.11.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.
To handle yourself, use your head. To handle others, use your heart
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.
Click Here to Expand Forum to Full Width