Re: Stupid Questions about users
Date: 21 Feb 2002 14:46:36 -0800
Message-ID: <6f53f9c1.0202211446.37e644ce_at_posting.google.com>
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