Creating users and priveledges [message #55421] |
Thu, 23 January 2003 12:51 |
Carlos Olmeda
Messages: 22 Registered: January 2003
|
Junior Member |
|
|
Good Afternoon,
Im an oracle newbie so I aplogize for the questions, I just ran a script to create a database, it apears to have run successfully, however my question is I want to assign users to this database with priveledges. Do I need to log onto sql to do this? if so how?. I know I can log into sql by typing system/manager and it will take me to the sql prompt, but then what. If I can get some instruction that would be great.
thank you.
Carlos
|
|
|
Re: Creating users and priveledges [message #55423 is a reply to message #55421] |
Thu, 23 January 2003 13:04 |
Siva Ram
Messages: 22 Registered: November 2001
|
Junior Member |
|
|
Hi Carlos
SQL> SHOW USER
O/P SYSTEM (O/P STANDS FOR OUTPUT)
SQL> CREATE USER USERNAME CARLOS IDENTIFIED BY CARLOS;
(You can give ur own password after IDENTIFIED BY)
SQL> GRANT CONNECT, RESOURCE TO CARLOS;
(this will allow you to connect to oracle and create all objects)
If you want to create a DBA, use
SQL> GRANT CONNECT, RESOURCE, DBA TO CARLOS;
(this will allow you to connect to oracle and create all objects including creating users and etc and logs in as DBA)
SQL> Select users from dba_users; (Will list DBA users)
If you have further questions, post here.
Hope this was useful to you !
Thank You
Siva Ram
|
|
|