Hello,
I'm trying to create a user for a virtual private catalog. What could be the reason for the error, please see below.
Thanks.
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 30 01:17:22 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> select name from v$database;
NAME
---------
RCAT
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATA/rcat/datafile/system.271.737601381
+DATA/rcat/datafile/sysaux.272.737601381
+DATA/rcat/datafile/undotbs1.273.737601383
+DATA/rcat/datafile/users.274.737601383
+DATA/rcat/datafile/rcat.281.737687711
SQL> create user vpc identified by vpc default tablespace rcat quota unlimited on rcat account unlock;
User created.
SQL> grant recovery_catalog_owner to vpc;
Grant succeeded.
SQL> grant register database to vpc;
grant register database to vpc
*
ERROR at line 1:
ORA-00990: missing or invalid privilege