Home » RDBMS Server » Security » New role object privileges
New role object privileges [message #61493] Thu, 29 April 2004 01:59 Go to next message
Ludek
Messages: 1
Registered: April 2004
Junior Member
Hi,

I create new database role. Is  possible copy object privileges to new role from existing user object?

Thank You

Ludek
Re: New role object privileges [message #61497 is a reply to message #61493] Thu, 29 April 2004 03:11 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

There is no direct way to do this, but it doesn't mean that there is no way to do this. You can user this script for the same :

select 'Grant ' || p.privilege || ' on ' || p.table_name || ' to new_role_name;'
from dba_tab_privs p
where
p.table_name = '&tablename';

Daljit Singh.
Re: New role object privileges [message #61499 is a reply to message #61497] Thu, 29 April 2004 05:17 Go to previous message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
Don't forget , that to give a privilege to object can only owner of this object and this can be a serious problem to creating a new role.
Previous Topic: Listener Security Patches
Next Topic: creating a new user and grant issues
Goto Forum:
  


Current Time: Fri Sep 17 05:58:10 CDT 2021