Home » RDBMS Server » Security » how to assign a same to role another person
icon11.gif  how to assign a same to role another person [message #290252] Fri, 28 December 2007 03:38 Go to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Hi guru,

I need how to assign a same role to another users.

Thank in advance

Regards
Kanish
Re: how to assign a same to role another person [message #290258 is a reply to message #290252] Fri, 28 December 2007 03:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
GRANT

Regards
Michel

[Updated on: Fri, 28 December 2007 04:05]

Report message to a moderator

Re: how to assign a same to role another person [message #290436 is a reply to message #290258] Fri, 28 December 2007 20:54 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Hi,
Thank 1st,

I need any single command to copy x role to y user (if any).


Thanks
Re: how to assign a same to role another person [message #290439 is a reply to message #290252] Fri, 28 December 2007 21:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I need any single command to copy x role to y user (if any).
No such single command exists.
I guess this means you need to go back to using ACCESS.
Re: how to assign a same to role another person [message #290482 is a reply to message #290436] Sat, 29 December 2007 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you precise what you mean.
Do you want to grant a role to a user?
Do you want to grant a user the privileges has a role?
Do you want to grant to user y all the roles granted to user x?
...
What do you want?

Regards
Michel
Re: how to assign a same to role another person [message #294357 is a reply to message #290252] Thu, 17 January 2008 05:43 Go to previous message
parthokonar
Messages: 17
Registered: September 2006
Location: india
Junior Member
I think dba_role_privs where grantee = ' ' might help you. and there is a procedure called dbms_metadata. might help you also.

Thanks
Partho
Previous Topic: Enterprise Single Sign-On (ESSO)
Next Topic: how to identifies list of roles
Goto Forum:
  


Current Time: Fri Mar 29 09:42:51 CDT 2024