-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|