Database Security Products (MOSC)

MOSC Banner

Need help combining two scripts

edited May 2, 2013 9:01PM in Database Security Products (MOSC) 8 commentsAnswered
I have a script that clones privileges of one user and builds sql statements to clone the sma eprivileges for another user. I am working on adding default user roles to my script and that part gives me errors.

"ERROR at line 3:
ORA-06550: line 3, column 1:
PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:
begin function pragma procedure subtype type <an identifier>
<a double-quoted delimited-identifier> current cursor delete
exists prior
The symbol "begin" was substituted for "SELECT" to continue.
ORA-06550: line 43, column 81:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
, * & - + / at mod remainder rem <an identifier>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center