Database Administration (MOSC)

MOSC Banner

Privileges to User DBA in your Organization

edited Mar 5, 2014 2:22PM in Database Administration (MOSC) 10 commentsAnswered

Hi Everyone!,

I'm working about privileges to user member of team DBA in my organization.

Oracle Database 11.2 this is version, now.

Can any help me about this?

Scripts

Script 1

SELECT DISTINCT  'GRANT '||PRIVILEGE ||' TO BODDBA;'

FROM DBA_SYS_PRIVS

WHERE (PRIVILEGE LIKE 'SELECT%'

OR PRIVILEGE LIKE '%CREATE%'

OR PRIVILEGE LIKE '%ALTER%'

OR PRIVILEGE LIKE '%DROP%'

OR PRIVILEGE LIKE '%EXECUTE%'

OR PRIVILEGE LIKE '%DELETE%'

OR PRIVILEGE LIKE '%INSERT%'

OR PRIVILEGE LIKE '%UPDATE%'

OR PRIVILEGE LIKE '%ANALYZE%'

OR PRIVILEGE LIKE '%COMMENT%'

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