Misc Oracle Scripts

•@ vs @@
@ find file in current directory
@@ find file in same path as the command file from which it was called

•object priv granted to PUBLIC
select * from dba_tab_privs
where grantee = ‘PUBLIC’;
•system priv granted to PUBLIC
select * from dba_sys_privs
where grantee = ‘PUBLIC’;
•roles granted to public
select * from dba_role_privs
where grantee = ‘PUBLIC’;

This entry was posted in oracle. Bookmark the permalink.