| Read Privlige on Code [message #270621] |
Thu, 27 September 2007 12:07  |
faiz_hyd
Messages: 294
Registered: February 2006
|
Senior Member |
|
|
Hi,
APP owner Owns The Objects ( tables / Views / Packages )
APP Owner Grants select,insert,update on the above objects to USER_ROLE.
User_role is assigned as default role to User_Account.
User account creates synonyms on the assigned table/view/packges and uses the synonyms.
The front end web based applications connects with User_account and it's all fine working.
Now developers on Support needs an account to work on issues, they need access like insert into tables ( some times very rare but requires ), Update the data ( some times very rare but requires ), and wants to view code from packages, How should this be accomplished,
If we give User_account the Risk management team has concerns and objects saying developer should not use the web account and the Application interface,
If i set up a read role having read on tables/viewthen how can they see the code.
it's on oracle 10g Rel 2.
Thanks
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
