Home » SQL & PL/SQL » SQL & PL/SQL » desc table that you can't select (11g r1)
desc table that you can't select [message #570722] Wed, 14 November 2012 18:41 Go to next message
neymarleo
Messages: 5
Registered: November 2012
Junior Member
if you grant select on a table to a user then u revoke select on this table that user still can desc this table, is this ok? what if i dont want that user to desc it?
Re: desc table that you can't select [message #570723 is a reply to message #570722] Wed, 14 November 2012 18:43 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
Senior Member
post results from following SQL

SELECT * FROM V$VERSION;

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

use COPY & PASTE of whole session that shows what you claim to be true.


SQL> connect user1/user1
Connected.
SQL> grant select on tab1 to user2;

Grant succeeded.

SQL> connect user2/user2
Connected.
SQL> select count(*) from user1.tab1;

  COUNT(*)
----------
         2

SQL> desc user1.tab1;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 COL1                                               VARCHAR2(8)
 COL2                                               VARCHAR2(8)
 COL3                                               VARCHAR2(8)

SQL> connect user1/user1
Connected.
SQL> revoke select on tab1 from user2;

Revoke succeeded.

SQL> connect user2/user2
Connected.
SQL> desc user1.tab1 
ERROR:
ORA-04043: object user1.tab1 does not exist


SQL> 


I can not reproduce what you report.
did you start new session after the REVOKE was issued?

[Updated on: Wed, 14 November 2012 18:55]

Report message to a moderator

Re: desc table that you can't select [message #570724 is a reply to message #570722] Wed, 14 November 2012 19:46 Go to previous message
neymarleo
Messages: 5
Registered: November 2012
Junior Member
you are right, i was granting create any index to that user .. thank you..
Previous Topic: Delete Partition
Next Topic: change External Directory from server to local machine path
Goto Forum:
  


Current Time: Sat Dec 20 15:23:36 CST 2014

Total time taken to generate the page: 0.10236 seconds