OraFAQ Forum: Server Administration » User wihtout Create user command

Home » RDBMS Server » Server Administration » User wihtout Create user command (oracle 9i windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

User wihtout Create user command [message #359393]

Sat, 15 November 2008 12:05

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

Report message to a moderator

Re: User wihtout Create user command [message #359395 is a reply to message #359393]

Sat, 15 November 2008 12:08

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

No. Why do you ask?

Report message to a moderator

Re: User wihtout Create user command [message #359397 is a reply to message #359395]

Sat, 15 November 2008 12:22

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?

Report message to a moderator

Re: User wihtout Create user command [message #359400 is a reply to message #359397]

Sat, 15 November 2008 12:33

Frank Naude
Messages: 4581
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.

Report message to a moderator

Re: User wihtout Create user command [message #359402 is a reply to message #359400]

Sat, 15 November 2008 12:45

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?

Report message to a moderator

Re: User wihtout Create user command [message #359405 is a reply to message #359402]

Sat, 15 November 2008 12:55

Frank Naude
Messages: 4581
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.

Report message to a moderator

Re: User wihtout Create user command [message #359407 is a reply to message #359405]

Sat, 15 November 2008 13:07

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

Report message to a moderator

Re: User wihtout Create user command [message #359423 is a reply to message #359397]

Sat, 15 November 2008 16:00

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;

Report message to a moderator

Re: User wihtout Create user command [message #359905 is a reply to message #359423]

Tue, 18 November 2008 12:19

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 18:55:17 CST 2024