Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to Handle new users in this senerio...
Hi,
No there is no easier way. And you probably don't want to grant select to
public, but to a set of users only.
To do this create a role, grant your tables to this role, and grant the role
to the enduser.
Everyone is doing it this way. This is not sqlserver! (Oops, now I used the
S-word)
Hth,
Sybrand Bakker, Oracle DBA
tim_mcconechy_at_my-dejanews.com wrote in message
<7i0qqj$nbb$1_at_nnrp1.deja.com>...
>Hi...
>I have the following scenario...
>A user sysadm owns everything in a schema.
>tables,Sequences,triggers,procedures...
>
>A new user is added and needs access to all of sysadm's objects.
>
>Code says "select * from users" for example.
>Not:
>"select * from sysadm.users"
>
>My thought was..
>create public synonyms on all objects;
>grant select,update,delete on all objects to public...
>
>But isn't there an easier way???
>
>I am just a little confused and wondering what people would do in this
>scenerio.
>
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Thu May 20 1999 - 06:42:48 CDT