Re: Stupid Questions about users

Jay Collins <jcollin_at_exis.net> wrote in message news:<Pine.LNX.4.33.0202211324070.20565-100000_at_tarpon.exis.net>...
> On Thu, 21 Feb 2002, Jim Kennedy wrote:
>
> >It is standard ansi sql
> >grant select on object_name to bob;
> >...

The other thing to remember is, that even if you DBA role privs, you cannot grant table privileges on other peoples objects. In other words, in order by grant select on fred.table1 to bob, you would have to logged in as fred. DBA's can, however, grant roles to any users so maybe a cleaner solution would be to log in as fred and grant select on a bunch of table to a role and then grant that role to bob, this would make life easier later is another user needed select privs on fred's tables.
>
> I figured out what I wanted.
>
> GRANT SELECT ON ALL_TABLES to user_id;
>
> Thanks!
Received on Thu Feb 21 2002 - 23:46:36 CET