Re: Newbie Oracle DBA question - Why CREATE ANY VIEW not shown

From: Richard <RSL101_at_gmail.com>
Date: Tue, 29 Jul 2008 19:20:59 -0700 (PDT)
Message-ID: <d86e4b1b-b359-407b-ac00-aa36d69f7078@i76g2000hsf.googlegroups.com>


On Jul 29, 3:33pm, Richard <RSL..._at_gmail.com> wrote:
> This just bawl me over -- why I can't get the privilleges to show, is
> it an output issue, set line limit ? This is the actuall screen dump
> ( replaced actual pw and customer name ). Platform is 64 bit solaris.
> Waiting for your expertise opinions. Thank you.
>
> -bash-3.00$ sqlplus /nolog
>
> SQL*Plus: Release 9.2.0.8.0 - Production on Tue Jul 29 15:18:11 2008
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> SQL> connect sys/MYPASSWD as sysdba
> Connected.
>
> SQL> select
> dbms_metadata.get_granted_ddl('SYSTEM_GRANT','MY_CUSTOMER') from dual;
>
> DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','MY_CUSTOMER')
> --------------------------------------------------------------------------------
> GRANT SELECT ANY DICTIONARY TO "MY_CUSTOMER"
> GRANT CREATE ANY SNAPSHOT TO "MY_CUSTOMER"
>
> SQL> grant create any view to "MY_CUSTOMER"
> 2 ;
>
> Grant succeeded.
>
> SQL> grant unlimited tablespace to "MY_CUSTOMER";
>
> Grant succeeded.
>
> SQL> select
> dbms_metadata.get_granted_ddl('SYSTEM_GRANT','MY_CUSTOMER') from dual;
> DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','MY_CUSTOMER')
> --------------------------------------------------------------------------------
> GRANT SELECT ANY DICTIONARY TO "MY_CUSTOMER"
> GRANT CREATE ANY SNAPSHOT TO "MY_CUSTOMER"
>
> SQL> select * from v$version
> 2 ;
>
> BANNER
> ----------------------------------------------------------------
> Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
> PL/SQL Release 9.2.0.8.0 - Production
> CORE 9.2.0.8.0 Production
> TNS for Solaris: Version 9.2.0.8.0 - Production
> NLSRTL Version 9.2.0.8.0 - Production

Help ? Received on Tue Jul 29 2008 - 21:20:59 CDT

Original text of this message