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

Don Gould wrote:
>
> I know that the MS product has a bunch of system stored procs for creating,
> modifying and deleting Users, Grants, Roles. (Dare I mention MS SQL Server
> in this news group?)
>
> Where can I find a reference that tells me what the qualivant functions are
> in PL/SQL?
>
> Cheers
>
> DiG

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;

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."