Databases Reference
In-Depth Information
Shared schema
Once the database has been registered, you can create a schema that can be shared
among the Enterprise Users.
Connected as SYSDBA a user named GUEST is created. This user is different from a
regular user, as this user is not authenticated at the database level but at the SSO
level. When a user is created using the IDENTIFIED GLOBALLY clause, the user is
authenticated in the LDAP.
Once the user has been created it is granted privileges, just like any regular user,
with the GRANT command.
$ sqlplus / as sysdba
SQL> create user GUEST identified globally;
SQL> grant CREATE SESSION to GUEST;
 
Search WWH ::




Custom Search