Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 674
  • Last Modified:

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
0
greddin
Asked:
greddin
  • 3
2 Solutions
 
slightwv (䄆 Netminder) 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 KumarProduction 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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now