think I'm almost there. but you sdeparated the cmds with ; by convenience, right? I get errors. only seems to have worked liek this: http://pastebin.com/w8HiqJjy
buuuut I'm not being able to liog with blah:foo, so maybe it didnt work
the error I talk when using . is: http://pastebin.com/zZSs1SGt
"when using ;"*
(sorry if I seem confused. I actually programmed for some time but this Oracle/Apex is a paradigm so different from PG and other things I used)
ahh ok. have to use the ; but only 1 cmd per line.
I should have started a band. good grief I need to sleep.
ok, only "grant create resource to blah;" failed for missing privilege. but it worked
Thank you so much.
just like cheeser for Java and RhodiumToad for PostgreSQL, you are now my idol for Oracle.
thanks a million.