Re: Creaste a view based on v_$session

Sure, *direct* select privilege on the view.

Regards,

Sybrand Bakker, Oracle DBA

"Brian Tkatch" <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> wrote in message news:39c7893e.1888379046_at_news.alt.net...
> I found a query via deja and it runs well. However, when I attempt to
> create a view, it gives me an error. Am I missing something?
>
> Brian
>
> SQL:
>
> CREATE OR REPLACE VIEW Check_Locks AS
> SELECT
> OWNER||'.'||OBJECT_NAME "Object",
> OS_USER_NAME "Terminal",
> ORACLE_USERNAME "Locker",
> PROGRAM "Program",
> NVL(lockwait,'ACTIVE') "Wait",
> DECODE(
> LOCKED_MODE,
> 2, 'ROW SHARE',
> 3, 'ROW EXCLUSIVE',
> 4, 'SHARE',
> 5, 'SHARE ROW EXCLUSIVE',
> 6, 'EXCLUSIVE',
> 'UNKNOWN'
> ) "Lockmode",
> OBJECT_TYPE "Object Type",
> SESSION_ID "Session ID",
> SERIAL# "Serial",
> C.SID
> FROM
> SYS.V_$LOCKED_OBJECT A,
> SYS.ALL_OBJECTS B,
> SYS.V_$SESSION C
> WHERE
> A.OBJECT_ID = B.OBJECT_ID AND
> C.SID = A.SESSION_ID
> ORDER BY
> 1 ASC,
> 5 Desc;
>
> Error:
> SYS.V_$SESSION c
> *
> ERROR at line 24:
> ORA-00942: table or view does not exist
Received on Tue Sep 19 2000 - 11:43:54 CDT