Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Automatic User creation
Atulya Swayankar
post Apr 15 2012, 09:44 PM
Post #1


Newbie
*

Group: Members
Posts: 3
Joined: 15-April 12
From: mangalore
Member No.: 47,082



I am doing my master project on oracle Database. I need to create a PL/SQL script to create user automatecally. Name of the users i am supposed to get from some table (say pr_id of table persons).

please help me to overcome this problem.
thaNKs in advance...

regards, Atulya (atulya.swayankar[at]gmail[dot]com)
Go to the top of the page
 
+Quote Post
dave
post Apr 16 2012, 02:55 AM
Post #2


Advanced Member
***

Group: Members
Posts: 5,206
Joined: 8-October 04
Member No.: 785



wellw hat have you come up with so far seeing as though we don't do homework on here
Go to the top of the page
 
+Quote Post
Atulya Swayankar
post Apr 16 2012, 05:53 AM
Post #3


Newbie
*

Group: Members
Posts: 3
Joined: 15-April 12
From: mangalore
Member No.: 47,082



i am very sorry if you thouht like that. I am learner and i got stuck at that point and no one is here to guide me. I am not telling you to write code. it would be even better if you give me some clue regarding this so that i could leran even more out of that.
Go to the top of the page
 
+Quote Post
burleson
post Apr 16 2012, 06:49 AM
Post #4


Advanced Member
***

Group: Members
Posts: 11,484
Joined: 26-January 04
Member No.: 13



Hi Atulya,

>> I am learner and i got stuck at that point and no one is here to guide me.

Oracle is not for neophytes, please read this!

http://www.dba-oracle.com/t_how_to_become_an_oracle_dba.htm

You should have several years of college computer science done BEFORE starting to learn Oracle.

I'll give you a hint,

You want to generate SQL from the values of the other SQL, like this:

CODE
spool runme.sql

select 'create user'||someval||';' from mytable;

spool off

@runme


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Atulya Swayankar
post Apr 19 2012, 01:01 AM
Post #5


Newbie
*

Group: Members
Posts: 3
Joined: 15-April 12
From: mangalore
Member No.: 47,082



@Donald thank you.. for links..

thanks for the help. Finally I have done automatic user creation..........
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 18th September 2014 - 08:39 AM