Privileges to User DBA in your Organization
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%'