Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL to Create/Edit/Drop Users, Groups and Roles
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