Re: PL/SQL to Create/Edit/Drop Users, Groups and Roles

From: Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk>
Date: Fri, 20 Jul 2001 10:51:42 +0100
Message-ID: <F43E6BAE5BB5D411A44C00805FBE740DCDC076@apps.leeds.lfs.co.uk>

Connor,

I know it was just a quick example, but the new user will default to SYSTEM as its default tablespace :o(

Regards,
Norman.

-----Original Message-----
From: Connor McDonald [mailto:connor_mcdonald_at_yahoo.com] Posted At: Thursday, July 19, 2001 7:52 PM Posted To: server
Conversation: PL/SQL to Create/Edit/Drop Users, Groups and Roles Subject: Re: PL/SQL to Create/Edit/Drop Users, Groups and Roles

>> There is not - but any DDL (create user/etc etc) can be wrapped
>> trivially in PL/SQL, for example

>> create procedure CREATE_USER(x varchar2) is
>> begin
>> execute immediate 'create user '||x||' identified by '||x;
>> end;

Norman Dunbar		EMail:	NDunbar_at_LynxFinancialSystems.co.uk
Database/Unix administrator	Phone:	0113 289 6265
Lynx Financial Systems Ltd.	Fax:	0113 201 7265
			URL:	http://www.LynxFinancialSystems.com
------------------------------------------------------------------------

Received on Fri Jul 20 2001 - 04:51:42 CDT