Create User [message #205857] |
Mon, 27 November 2006 23:15 |
ehegagoka
Messages: 493 Registered: July 2005
|
Senior Member |
|
|
hi!,
just want to ask if my user is not a dba, from the dba user what role/priviledge do i need to grant to the non-dba user for it to create another user? i hope i've explained it well.
thanks,
rhani
opppss got it c",)
[Updated on: Mon, 27 November 2006 23:25] Report message to a moderator
|
|
|
|
Re: Create User [message #205913 is a reply to message #205857] |
Tue, 28 November 2006 02:26 |
bwetkstr
Messages: 114 Registered: August 2005
|
Senior Member |
|
|
Don't think this is save.
And seen that you don't know the dba privillege to grant to a user, I have the idea that you don't really know what affect you might cause by granting that role. I would suggest to find an other way.
Kr
Karel
|
|
|
Re: Create User [message #205926 is a reply to message #205913] |
Tue, 28 November 2006 03:02 |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
I can understand not wanting to grant DBA to a user.
The privilege you need to grant to user A to allow them to create other users is (suprisingly) CREATE USER.
If you create a role with all the privs that the new users will need, then if you do:GRANT <user role> TO USER_A WITH ADMIN OPTION then user A will be able to grant this role to the newly created users.
|
|
|
Re: Create User [message #206121 is a reply to message #205926] |
Tue, 28 November 2006 19:53 |
ehegagoka
Messages: 493 Registered: July 2005
|
Senior Member |
|
|
hi!
thank you so much sir, im not going to use it for production, it's just a part of me learning oracle. i just want to know some, if not all, the "backend" or how does this "dba user" be able to do this and that, what are those "characteristics" that this user have for him to be able to do so many things in the database. thank you so much again sir/mam for your replies =)
|
|
|