Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL to Create/Edit/Drop Users, Groups and Roles

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

From: Don Gould <dig_at_bvc.com.au>
Date: Fri, 20 Jul 2001 01:26:43 GMT
Message-ID: <nNL57.16277$Xr6.137100@news-server.bigpond.net.au>

Talk about making it simple?!

Thanks for this. The last time I did a pjt with Orcale, I found that they make things much simpler than good old M$

Cheers

DiG

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:3B572C41.1D63_at_yahoo.com...
> 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..."
Received on Thu Jul 19 2001 - 20:26:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US