OraFAQ Forum: Security » New role object privileges

Home » RDBMS Server » Security » New role object privileges

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

New role object privileges [message #61493]

Thu, 29 April 2004 01:59

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

Report message to a moderator

Re: New role object privileges [message #61497 is a reply to message #61493]

Thu, 29 April 2004 03:11

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.

Report message to a moderator

Re: New role object privileges [message #61499 is a reply to message #61497]

Thu, 29 April 2004 05:17

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.

Report message to a moderator

Previous Topic:	Listener Security Patches
Next Topic:	creating a new user and grant issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 14:23:49 CDT 2025