Hello..

I have to create close to 25 users on 3 instances and I have a list of user names. I am trying to
run the below queries hoping to enter the username only once when i run the script, but this does not work.
How do I modify the sql to do that? (Interactive on the prompt)..

<>

create user &1 identified by &1
default tablespace aapdata
temporary tablespace aapdata
quota unlimited on aapdata;

alter user &1 quota 0 on system;

grant connect to &1;

grant cgaap_user to &1;

<>

Secondly, I can know the available roles from dba_roles, and I know the users and their roles through
user_role_privs.granted_role, but how do i see the privileges for the same (which view?)..
I can see the same in TOAD, but not SQL Plus..

Thanks, ST2000