Re: Grant select any tables to user

From: David Sharples <david.sharples3_at_ntlworld.com>
Date: Mon, 26 May 2003 23:49:34 +0100
Message-ID: <8SwAa.13228$sJ4.8618@newsfep4-winn.server.ntli.net>

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:5e55dvs2f0fhg0pkmto6rvulsjvdss0pl1_at_4ax.com...
> Will the statement
> grant select any tables to Peter;
>
> allow Peter to run a select statement on a table created by SYS?
>
>
> I did just that but I got the following error
>
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> Did I miss some privileges that I should have granted to Peter?
> Thanks
>

did you put sys in front of the table name?

e.g

SQL> connect internal
Connected.
SQL> drop user dave
  2 /

User dropped.

SQL> create user dave identified by dave;

User created.

SQL> grant create session to dave;

Grant succeeded.

SQL> grant select any table to dave;

Grant succeeded.

SQL> select table_name from tabs where rownum < 5;

TABLE_NAME

---

ACCESS$

AQ$_MESSAGE_TYPES
AQ$_PENDING_MESSAGES
AQ$_PROPAGATION_STATUS

SQL> select count(*) from ACCESS$;

  COUNT(*)

---

      5337

SQL> connect dave/dave;
Connected.
SQL> select count(*) from sys.ACCESS$;

  COUNT(*)

---

      5337

SQL> select count(*) from ACCESS$;
select count(*) from ACCESS$

                     *

ERROR at line 1:
ORA-00942: table or view does not exist

SQL> Received on Mon May 26 2003 - 17:49:34 CDT