Re: Newbie Role Q

Elliot Ross wrote:
>
> I posted this once before, I did not get a response, however my ISP did
> replace a server, so god only knows......
>
> I thought that I could define a role (ie Developer), grant create etc to
> role developer, then add user_ID to the role, and voila, user_ID has
> create etc rights.
>
> It did not work. What am I doing wrong ??
> --
> My EMail address contains a # to try to
> thwart mail spamming.

I guess you are looking for something like this...

For the role...

create role devp_priv;
grant create session,

       alter  session,
       create sequence,
       create synonym,
       create table,
       create view,
       create procedure,
       create trigger,
       execute any procedure
to     devp_priv;

(if your bold, you may wish to include "select any table" as well)

For the schema...

   grant ... on schema.object_name to devp_priv;

   for "...", refer to docs as to what privs (select, insert, etc.) can be granted to the various object types.

   (do this for views, packages, tables, procedures, functions, sequences, etc for required objects).

For the developers...

  grant devp_priv to username;

Hope this helps,
Greg... Received on Fri May 30 1997 - 00:00:00 CDT