How to verify user permissions to tablespace?

Another user has told me the following command have already been issued successfully.  

CREATE USER myuser INDENTIFIED BY myuser;
GRANT CONNECT, RESOURCE TO myuser;

How can I validate this was done. Is there a SQLPlus command or can I use Oracle SQL Developer?

I just want to see that these changes have been implemented.

Thanks
greddinAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
To verify the user:
Select ussername from dba_users where username='MYUSER';

For the roles:
Select granted_role from dba_role_privs where grantee='MYUSER'
0
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
to "verify user permissions to tablespace?", you can run the below query :

select * from dba_ts_quotas
where username ='MIS_OWNER'  ---> change the user name here accordingly
orer by tablespace_name;

if you do not have access to dba_ts_quotas, then you can run the below :

select * from user_ts_quotas
order by tablespace_name; --> this will give the same information but for the current user who runs this query.

Thanks
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
You then have to accept the answers/split points and you should not delete the question.
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
oh..i am sorry, i thought you wanted to delete the question but infact you had raised it to get it closed.

Thanks,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.