Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Unable to grant select on v$session (Read 4081 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Unable to grant select on v$session
10.08.08 at 14:51:25
 
Unable to grant select on v$session
 
In order to give a user access to v$session I need to grant the select privilege to him. Unfortunately I don't seem to be able to do that:

SQL> grant se
lect on v$session to scott;
grant sele[\tt][tt]ct on v$session to scott
            *
ERROR at line 1:
ORA-02030: can only se[\tt][tt]lect from fixed tables/views

 
Aparently v$session is a synonym for v_$session. Granting select on this view works fine.
Back to top
 
« Last Edit: 10.08.08 at 14:55:06 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1