Home » RDBMS Server » Server Administration » User wihtout Create user command (oracle 9i windows xp)
User wihtout Create user command [message #359393] Sat, 15 November 2008 12:05 Go to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
Hi friends,

Is it possible to create a oracle user without create user command?

Thanks in advance,

uns
Re: User wihtout Create user command [message #359395 is a reply to message #359393] Sat, 15 November 2008 12:08 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
No. Why do you ask?
Re: User wihtout Create user command [message #359397 is a reply to message #359395] Sat, 15 November 2008 12:22 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
My Senior DBA was saying that today. so i just wanted to know if its really possible?
Re: User wihtout Create user command [message #359400 is a reply to message #359397] Sat, 15 November 2008 12:33 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Well, let's put it this way: there is only one officially supported way of doing it. I guess you can also hack the dictionary by inserting into SYS.USER$ (and related tables). Just don't try it on a production database.
Re: User wihtout Create user command [message #359402 is a reply to message #359400] Sat, 15 November 2008 12:45 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
So what are other related tables with user creation? so if i insert to this table all the not null values it will create a user. Is that correct?
Re: User wihtout Create user command [message #359405 is a reply to message #359402] Sat, 15 November 2008 12:55 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
I don't know nor do I want to know. People playing with the dictionary will burn their fingers. Rather spend your time on something constructive.
Re: User wihtout Create user command [message #359407 is a reply to message #359405] Sat, 15 November 2008 13:07 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
Thank You very much for your advice and assistance. I was just curious Smile
Re: User wihtout Create user command [message #359423 is a reply to message #359397] Sat, 15 November 2008 16:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Your coworker may be talking about creating a new user like the following:

grant create session to newuser identified by newpassword;

Re: User wihtout Create user command [message #359905 is a reply to message #359423] Tue, 18 November 2008 12:19 Go to previous message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
Thank You very much ebrian. Yes you are right he was talking about this and i was curious to know if there is something like that.

Smile

Previous Topic: SGA Heap size 2273K exceeds notification thres
Next Topic: How Oracle works internally
Goto Forum:
  


Current Time: Fri Dec 09 08:01:36 CST 2016

Total time taken to generate the page: 0.10217 seconds