Home » SQL & PL/SQL » SQL & PL/SQL » Grant (oracle 9i)
Grant [message #300398] Fri, 15 February 2008 05:26 Go to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

Hot to grant all permission of one user to another user?

Thanks
Mano
Re: Grant [message #300399 is a reply to message #300398] Fri, 15 February 2008 05:33 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
either create a role and grant the required privileges to that role and then grant that role to the other user or explicitly grant each privilege.


regards,
Re: Grant [message #300403 is a reply to message #300398] Fri, 15 February 2008 05:37 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Friend,

Can you post on example? please

Mano
Re: Grant [message #300409 is a reply to message #300403] Fri, 15 February 2008 05:48 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
google for CREATE ROLE / GRANT.


regards,
Re: Grant [message #300421 is a reply to message #300398] Fri, 15 February 2008 06:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no statement to grant "all permission of one user to another user"
Permissions are on objects not users.
You have to grant permission on each object.

Regards
Michel
Re: Grant [message #300427 is a reply to message #300398] Fri, 15 February 2008 06:35 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Dear Michel,

grant all priviliges to user_name;

This statement true or not?

Thanks
Mano

Re: Grant [message #300441 is a reply to message #300427] Fri, 15 February 2008 07:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try it?

Regards
Michel
Re: Grant [message #300550 is a reply to message #300398] Fri, 15 February 2008 22:00 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Michel,

I tried. It's working yaar.

Thanks

Mano
Re: Grant [message #300559 is a reply to message #300550] Sat, 16 February 2008 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This does not fit the requirements you stated in your first post.
SQL reference
Oracle Database provides the ALL PRIVILEGES shortcut for granting all the system privileges listed in Table 18-1, except the SELECT ANY DICTIONARY privilege.

This has no relation with: "grant all permission of one user to another user".

Regards
Michel
Re: Grant [message #300580 is a reply to message #300398] Sat, 16 February 2008 05:00 Go to previous message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
> This does not fit the requirements you stated in your first post.

In fact, it massively exceeds them. As lots of "<action> ANY <object>" grants are included (eg. SELECT ANY TABLE, CREATE ANY TABLE), he has in fact access to all other users.

When you want to CREATE/ALTER/DROP objects in other users, you need these ANY privileges anyway. Then you are able to do required action in all users; it is not possible to have this privilege for only one another user. But you should rather re-think your design instead of implementing this (granting ANY/ALL privilege).
Previous Topic: Decode in the where clause
Next Topic: Read/Write text files
Goto Forum:
  


Current Time: Sun Dec 04 12:54:42 CST 2016

Total time taken to generate the page: 0.12175 seconds