Home » RDBMS Server » Security » how to add a new user?
how to add a new user? [message #16975] Sun, 19 December 2004 19:22 Go to next message
Vrinda V
Messages: 17
Registered: October 2004
Junior Member
Now I am accessing Oracle with username system. I want to add a user named vrinda and grant different privileges to it.Please help me with the syntax of how to create a new user?

Thanks in advance
Re: how to add a new user? [message #16976 is a reply to message #16975] Sun, 19 December 2004 20:24 Go to previous messageGo to next message
Deepa
Messages: 269
Registered: November 2000
Senior Member
CREATE USER vrinda
IDENTIFIED BY <pwd>
DEFAULT TABLESPACE <tblspacename>
QUOTA 10M ON <tblspacename>
TEMPORARY TABLESPACE temp

Then grant priviledges as u need.

grant connect to vrinda;
Re: how to add a new user? [message #16977 is a reply to message #16975] Sun, 19 December 2004 22:15 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Oracle online documentation can be found at tahiti.oracle.com. The site requires a free OTN account.

MHE
Previous Topic: Oracle Roles
Next Topic: Grant and Revoke
Goto Forum:
  


Current Time: Thu Mar 28 14:58:06 CDT 2024