Solved

How to verify user permissions to tablespace?

Posted on 2010-09-16
4
670 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:greddin
  • 3
4 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 400 total points
ID: 33696542
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
 
LVL 28

Assisted Solution

by:Naveen Kumar
Naveen Kumar earned 100 total points
ID: 33697839
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
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 33698316
You then have to accept the answers/split points and you should not delete the question.
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 33698320
oh..i am sorry, i thought you wanted to delete the question but infact you had raised it to get it closed.

Thanks,
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle Query - Return results based on minimum value 8 46
Read XML values 8 58
UTL_FILE invalid file operation 5 46
Updating a temp table inside a PL/SQL block 3 51
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question