Home » SQL & PL/SQL » SQL & PL/SQL » Grant User (9.2.07)
icon9.gif  Grant User [message #293882] Tue, 15 January 2008 07:52 Go to next message
eloyhasan
Messages: 8
Registered: January 2008
Junior Member
Hi

i have created a new user and i defined some roles like this;

Grant select, insert, update, delete on apps.xxxt_hasan to xxfr_user;


but i'd like to learn how to grant to new user as apps user
Thanks

Eloyhasan

Re: Grant User [message #294093 is a reply to message #293882] Wed, 16 January 2008 07:28 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
As my knowledge, there is no relation between database user and apps user.
To create Apps user, you need to have one user with system administrator responsibility.
Then you can create another user using the following navigation.

1. Goto System Administrator responsibility.
2. Security -> User -> Define.
3. Attach required responsibilities.

By
Vamsi
Re: Grant User [message #294095 is a reply to message #293882] Wed, 16 January 2008 07:48 Go to previous messageGo to next message
eloyhasan
Messages: 8
Registered: January 2008
Junior Member
Hi Vamsi thanks for help but i think my explanation was wrong i'll try again Smile

i have just created a database user 'x', now i want to grant this user like dba user .

i know how to grant for table or view to this user as 'grant delete on 'Table' to xxx_user ' etc.. and i also want to grant to my new user like database admin user.

Thanx

Eloyhasan





Re: Grant User [message #294289 is a reply to message #294095] Thu, 17 January 2008 02:12 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I don't know why you have posted this in Apps Forum.
If I'm not wrong, you have created a user 'X' and you want to give dba privileges to the user 'X'.

Right?

By
Vamsi
Re: Grant User [message #294319 is a reply to message #293882] Thu, 17 January 2008 03:56 Go to previous message
apps.user.123@gmail.com
Messages: 1
Registered: January 2008
Junior Member
SQL> Grant DBA to <User Name>
This will grant all the privileges to this particular user.

Regards,
AppsUser
Previous Topic: Definite Indexing scenarios
Next Topic: partitioning table with sequence made in java base 36
Goto Forum:
  


Current Time: Fri Dec 09 11:27:32 CST 2016

Total time taken to generate the page: 0.09821 seconds