RE: Database priviliges

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Wed, 25 May 2005 11:54:39 -0700 (PDT)
Message-ID: <20050525185439.27626.qmail@web51307.mail.yahoo.com>

Thanks everybody for the comment.
"Mercadante, Thomas F (LABOR)" <Thomas.Mercadante_at_labor.state.ny.us> wrote:Sanjay,

Not to the whole schema. It is fairly trivial to generate a sql script to grant select access to all of the objects to the user (or to a role that has been granted to the user).

Something like:

declare
cursor c1 is
select 'grant select on ' || object_name || ' to sanjay_role' out_line from user_objects
where object_type in ('VIEW','TABLE')
;
cid INTEGER;
v_numrows number;

begin

for c1_rec in c1 loop
execute immediate rtrim(c1_rec.out_Line,';'); end loop;

end;
/

Tom

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra Sent: Wednesday, May 25, 2005 2:23 PM
To: oracle-l_at_freelists.org
Subject: Database priviliges

Hi
=20
I have one schema in database named "A" Schema A has all of the database object like tables etc. Now I want to give Read only access for all Schema A Tables to "Sanjay" user. Is there any way that I can do without granting individually on table basis. What I am looking is full schema Read only kind of priviliges.
=20
Database is 9.2

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20 http://mail.yahoo.com=20

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 25 2005 - 14:59:26 CDT