* Print an message that the user lacks privilegs. * Grant necessary privileges to the student database. */ĮXECUTE IMMEDIATE 'DROP USER student CASCADE' ĮXECUTE IMMEDIATE 'CREATE USER student'||CHR(10) * Conditonally drop the non-container database user. || 'CREATE TRIGGER, CREATE TYPE,'||CHR(10)ĮXECUTE IMMEDIATE 'GRANT c#studentrole TO c#student' || 'CREATE SESSION, CREATE TABLE,'||CHR(10) || 'CREATE PROCEDURE, CREATE SEQUENCE,'||CHR(10) */ĮXECUTE IMMEDIATE 'GRANT CREATE CLUSTER, CREATE INDEXTYPE,'||CHR(10) */ĮXECUTE IMMEDIATE 'CREATE USER c#student'||CHR(10)ĮXECUTE IMMEDIATE 'CREATE ROLE c#studentrole CONTAINER = ALL' * Create a container user with 200 MB of space. */ĮXECUTE IMMEDIATE 'DROP ROLE c#studentrole' * Conditionally rop the container c#studentrole role. */ĮXECUTE IMMEDIATE 'DROP USER c#student CASCADE' * Conditionally drop existing user and role. * Check for a container database, set control variable Work in both pre-container Oracle databases, like 10g and 11g. * Check for a container-enabled column, which enables this to * Check if the current user is the superuser. 'SELECT cdb FROM v$database WHERE cdb = ''YES''' */ĭbms_output.put_line ( 'You must be the SYSTEM user to drop and create a user.' ) */ EXECUTE IMMEDIATE 'GRANT CREATE CLUSTER, CREATE INDEXTYPE,' || CHR ( 10 ) || 'CREATE PROCEDURE, CREATE SEQUENCE,' || CHR ( 10 ) || 'CREATE SESSION, CREATE TABLE,' || CHR ( 10 ) || 'CREATE TRIGGER, CREATE TYPE,' || CHR ( 10 ) || 'CREATE VIEW TO student' ĮLSE /* Print an message that the user lacks privilegs. */ EXECUTE IMMEDIATE 'CREATE USER student' || CHR ( 10 ) || 'IDENTIFIED BY student' || CHR ( 10 ) || 'DEFAULT TABLESPACE users' || CHR ( 10 ) || 'QUOTA 200M ON users' || CHR ( 10 ) || 'TEMPORARY TABLESPACE temp' WHERE username = 'STUDENT' ) LOOP EXECUTE IMMEDIATE 'DROP USER student CASCADE' */ EXECUTE IMMEDIATE 'GRANT c#studentrole TO c#student' ĮLSE /* Conditonally drop the non-container database user.
*/ EXECUTE IMMEDIATE 'GRANT CREATE CLUSTER, CREATE INDEXTYPE,' || CHR ( 10 ) || 'CREATE PROCEDURE, CREATE SEQUENCE,' || CHR ( 10 ) || 'CREATE SESSION, CREATE TABLE,' || CHR ( 10 ) || 'CREATE TRIGGER, CREATE TYPE,' || CHR ( 10 ) || 'CREATE VIEW TO c#studentrole' */ EXECUTE IMMEDIATE 'CREATE ROLE c#studentrole CONTAINER = ALL' */ EXECUTE IMMEDIATE 'CREATE USER c#student' || CHR ( 10 ) || 'IDENTIFIED BY student' || CHR ( 10 ) || 'DEFAULT TABLESPACE users' || CHR ( 10 ) || 'QUOTA 200M ON users' || CHR ( 10 ) || 'TEMPORARY TABLESPACE temp' WHERE ROLE = 'C#STUDENTROLE' ) LOOP EXECUTE IMMEDIATE 'DROP ROLE c#studentrole' WHERE username = 'C#STUDENT' ) LOOP EXECUTE IMMEDIATE 'DROP USER c#student CASCADE'
*/ IF container THEN /* Conditionally drop a container user. WHERE column_name = 'CDB' ) LOOP /* Check for a container database, set control variableĪnd exit when found. */ FOR j IN ( SELECT DISTINCT column_name USER = 'SYSTEM' THEN /* Check for a container-enabled column, which enables this to */ FOR i IN ( SELECT USER FROM dual ) LOOP /* Perform tasks as superuser. Sql_statement CONSTANT VARCHAR2 ( 50 ) : = 'SELECT cdb FROM v$database WHERE cdb = ' 'YES' '' īEGIN /* Check if the current user is the superuser. * Constant required for pre-container databases to avoid a * Weakly structured system reference cursor.
Key software oracle olr cannot be opened.error 2 install#
$ORACLE_HOME/bin/sqlplus you port this shell script to an environment where rlwrap is not installed, it simply prints the error message and advises you to install the rlwrap package.Īs always, I hope this helps those looking for a solution. Rlwrap sqlplus "Command-line history unavailable: Install the rlwrap package."
0 kommentar(er)
