This content has been marked as final. Show 5 replies
What tool do you plan to run the scripts? SQL*PLUS? SQL*Developer? Something else?
If you have to log in again with script 2 is there any point to combining the scripts?
Anyway, did you try simply pasting the contents of script 2 to the end of script 1? Alternately, in SQL*PLUS you can call a script from a script using the '@' (run) command and just run script 2 at the end of script 1
I am using command prompt
C> sqlplus / as sysdba
SQL*Plus: Release 220.127.116.11.0 Production on Thu Feb 7 14:32:57 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 18.104.22.168.0
so it will create new user and have the necessary access details for this user this is fine
using user name and password
SQL > sqlplus
Enter user-name :*****
Anyway, did you try simply pasting the contents of script 2 to the end of script 1? Alternately, in SQL*PLUS you can call a script from a script using the '@' (run) command and just run script 2 at the end of script 1how to pass the username and password in the script.
In SQL*Plus, if you want to log in as a different user (say SCOTT, password TIGER), you can use the CONNect command:
In this case, you may want to use substitution variables, like this
DEFINE username = scott DEFINE password = tiger -- This part is done by SYS: CREATE USER &username IDENTIFIED BY &password; GRANT some_role TO &username; ... -- Now connect as the new user and run script_2.sql: CONN &username/&password@dbname @script_2
Super this is what i am looking for.
Keep in mind that your example showed a local direct connection to the database - and Frank's posting will work for that. However, when the user runs this installation remotely and uses a TNS connection, this approach will not work.
You also need to pass the connection string to the CONNECT command, that the user used to launch SQL*Plus and ran the 1st part of the installation (creating the user).
Doing this (passing connection string) safely and securely is problematic. So much so that even Oracle stopped using this approach with Apex v3's installer.
There is an alternative approach - as the SYS user is used, it can create the user objects on behalf of the user. E.g.
The only objects that cannot be created like this, are private/local database links and materialised views, if I recall correctly. In such a case, the installation needs to create a procedure as the user schema, running with definer rights, that creates the object. When SYS calls this procedure during the installation, the procedure runs as FOO and creates the database link/whatever as FOO.
--// connected as a SYS user --// create user create user FOO identified by ...; --// set user privs grant .. to FOO; --// change resolution scope to user schema alter session set current_schema=FOO; --// create user objects (these are created by --// SYS in the FOO schema) create table ...; create sequence ..; create trigger ...; etc...