Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: User Privileges
Forget #1. That is the equivalent of granting DBA to PUBLIC.
Use #2 ... but instead of doing it manually invest an hour and write a stored procedure to get object names from xxx_OBJECTS and grant the object privileges using native dynamic SQL. Write once ... use many times ... you could even run it nightly under DBMS_JOB if you are really nervous about this.
Daniel Morgan
Mytskidis Georgios wrote:
> Hello
>
> I've a user named MAINUSER which owns a variety of objects
> (tables,sequences,...). I need to create a few other users (i.e.
> USER1,USER2,...) who need to have FULL ACCESS on every object that the
> MAINUSER owns. I see two ways for doing so :
> 1). Grant DBA role to all (USER1,USER2,...); not very elegant or safe
> 2). Grant SELECT,INSERT,UPDATE,DELETE ON <MAINUSER.object> TO
> USER1,USER2,...; this approach has the risk that an object might be
> forgotten or when a new object is created to run the above Grant for that
> new object.
>
> Is there any other more elegant-fast way ?
>
> Thanks in advance for your reply
>
> --
> --
>
> Best Regards
>
> MYTSKIDIS GEORGIOS
> Mytskidis_G_at_GI-Net.Gr
Received on Wed Mar 13 2002 - 09:47:10 CST