Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 57998

Oracle Database 11g (not 11g R2). Please also tag oracle for search purposes.

1
vote
Try this... select owner,table_name,grantable from dba_tab_privs where grantee = 'SCOTT' and privilege = 'SELECT'; Change SCOTT to the user you are interested in.
answered Jul 28 '15 by Stringer
0
votes
You can also avoid the tnsnames.ora file by using the EZ Connect method. sqlplus scott/tiger@asdasdasd.com:1524/<service name goes here> You can get your service name by running lsnrctl status comm …
answered Jul 30 '15 by Stringer