SCOTT@NCBI>connect / as sysdba
Connected.
SYS@NCBI>create user privs identified by "1";
User created.
Elapsed: 00:00:00.03
SYS@NCBI>grant create session, select any table to privs;
Grant succeeded.
Elapsed: 00:00:00.03
SYS@NCBI>connect privs/1
Connected.
PRIVS@NCBI>select count(*) from ncbi.SAMSUNG_XCL;
COUNT(*)
----------
25
Elapsed: 00:00:00.34
PRIVS@NCBI>connect / as sysdba
Connected.
SYS@NCBI>revoke select any table from privs;
Revoke succeeded.
Elapsed: 00:00:00.01
SYS@NCBI>connect privs/1
Connected.
PRIVS@NCBI>select count(*) from ncbi.SAMSUNG_XCL;
select count(*) from ncbi.SAMSUNG_XCL
*
ERROR at line 1:
ORA-00942: table or view does not exist
Elapsed: 00:00:00.01
PRIVS@NCBI>select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for 64-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
Elapsed: 00:00:00.03
PRIVS@NCBI>select * from user_tab_privs;
no rows selected
Elapsed: 00:00:00.14
PRIVS@NCBI>select * from user_sys_privs;
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
PRIVS CREATE SESSION NO
Elapsed: 00:00:00.03
PRIVS@NCBI>connect / as sysdba
Connected.
SYS@NCBI>grant select any table to privs;
Grant succeeded.
Elapsed: 00:00:00.00
SYS@NCBI>connect privs/1
Connected.
PRIVS@NCBI>select count(*) from ncbi.SAMSUNG_XCL;
COUNT(*)
----------
25
Elapsed: 00:00:00.34
PRIVS@NCBI>select * from user_sys_privs;
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
PRIVS CREATE SESSION NO
PRIVS SELECT ANY TABLE NO
Elapsed: 00:00:00.01
PRIVS@NCBI>