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

From: Richard <RSL101_at_gmail.com>
Date: Tue, 29 Jul 2008 12:33:13 -0700 (PDT)
Message-ID: <cebaec00-e004-4b5a-9fa0-b81b2ffdbd24@27g2000hsf.googlegroups.com>

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 Received on Tue Jul 29 2008 - 14:33:13 CDT