Database Security Products (MOSC)

MOSC Banner

manage User Rol and Object Privilege question - grant 'select tables' to a Role, then grant role to

edited Aug 12, 2010 8:25AM in Database Security Products (MOSC) 4 commentsAnswered
Hello friends:

Here is a basic question could be simple as I used to think about it - but it didn't work as expected - user cannot see table data (select doesn't work).  Oracle version is 10.2.0.1.  Application is Siebel crm.

we frequently got developers' request that users need to 'select-only' priviledge to access some tables.  Thus, we design it by creating a Role, and then granting 'select privilege' to tables to Role, and then grant the role to user.  The steps are in below:

(1).  Create role RO (for 'read-only'):

 Select 'GRANT SELECT ON OwningUser.'||Table_Name||' TO RO;'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center