OraFAQ Forum: Security » how to assign a same to role another person

Home » RDBMS Server » Security » how to assign a same to role another person

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

how to assign a same to role another person [message #290252]

Fri, 28 December 2007 03:38

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

Report message to a moderator

Re: how to assign a same to role another person [message #290258 is a reply to message #290252]

Fri, 28 December 2007 03:57

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

Re: how to assign a same to role another person [message #290439 is a reply to message #290252]

Fri, 28 December 2007 21:44

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.

Report message to a moderator

Re: how to assign a same to role another person [message #290482 is a reply to message #290436]

Sat, 29 December 2007 02:04

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: how to assign a same to role another person [message #294357 is a reply to message #290252]

Thu, 17 January 2008 05:43

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 14 17:59:27 CDT 2025