Privileges in Personal Oracle 7.3 for Win95

From: <ildavid_at_my-dejanews.com>
Date: Tue, 01 Sep 1998 11:00:50 GMT
Message-ID: <6sgk52$4ef$1@nnrp1.dejanews.com>

I have a problem with Personal Oracle 7.3. When I work as SYSTEM ( 'system' account ) and try to run a procedure which contains
a following statement :

select privilege into v_var from dba_sys_privs where .... ,

I receive an error message :

PS-00201 : identifier 'SYS.DBA_SYS_PRIVS' must be declared.

The only solution I found is to connect as SYS, give explicite privilege to SYSTEM grant select on dba_sys_privs to system ,

when, after reconnection to SYSTEM the procedure runs.

May anybody explain me is it a bug or a security reason ?

Thank You for reply,

                                                        David.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 01 1998 - 06:00:50 CDT