Home » RDBMS Server » Security » create user
create user [message #187076] Thu, 10 August 2006 15:36 Go to next message
limbe
Messages: 20
Registered: July 2006
Location: Limbe, Cameroon
Junior Member
Hello!

How can I create oracle db 10g user using PL/SQL.
My problem is that I am using a client software to develop my app.
I want to create user in the client and automatically create them in the databse.

Hugues
Re: create user [message #187147 is a reply to message #187076] Fri, 11 August 2006 02:15 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
PL/SQL? Dynamically, using EXECUTE IMMEDIATE.
Re: create user [message #424459 is a reply to message #187076] Fri, 02 October 2009 08:18 Go to previous messageGo to next message
mohd_dba
Messages: 19
Registered: October 2009
Junior Member
As far as I know there won`t be any PL/SQL script for creation of New Schema in Oracle 10g.

Syntax :

Create user<username> identified by<pwd> default tablespace<tbs name>

If it is there please let me know.

Thanks,
Afroze.
Re: create user [message #424460 is a reply to message #424459] Fri, 02 October 2009 08:20 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I don't think OP has waited 3 years for your answer.

Regards
Michel
Previous Topic: lost sys and system passwords
Next Topic: Use of dbms_crypto packageto encrypt table columns
Goto Forum:
  


Current Time: Tue Dec 03 05:06:07 CST 2024