StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3573411
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-08-26T08:37:11.880
FavoriteCount
0
LastActivityDate
2010-08-26T08:37:11.880
LastEditDate
LastEditorUserId
0
OwnerUserId
362880
ParentId
3573190
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Firstly create sample users "user_a" and "user_b": <pre><code>SQL> create user user_a identified by user_a default tablespace users temporary tablespace temp; SQL> create user user_b identified by user_b default tablespace users temporary tablespace temp; SQL> grant connect to user_a, user_b; SQL> grant create session to user_a, user_b; SQL> grant create table to user_a, user_b; SQL> grant create view to user_a, user_b; SQL> alter user user_a quota unlimited on users; SQL> alter user user_b quota unlimited on users; </code></pre> Now connect as USER_A and create sample objects: <pre><code>SQL> conn user_a/user_a Connected. SQL> create table tbl_a(id number, text varchar2(200)); Table created. SQL> create view view_a as select id, text from tbl_a; View created. </code></pre> Then connect as USER_B and create sample objects: <pre><code>SQL> conn user_b/user_b Connected. SQL> create table tbl_b(id number, text varchar2(200)); Table created. SQL> create view view_b as select id, text from tbl_b; View created. </code></pre> And finally connect back as USER_A a search grants for his table TBL_A: <pre><code>SQL> conn user_a/user_a Connected. SQL> select count(1) from ALL_TAB_PRIVS where grantor = 'USER_A' and PRIVILEGE = 'SELECT' and GRANTEE = 'USER_B'; </code></pre> Out is: <pre><code> COUNT(1) ---------- 0 </code></pre> Now grant select on view VIEW_A for USER_B: <pre><code>SQL> grant select on view_a to user_b; Grant succeeded. </code></pre> And again try search grants for USER_B to view object VIEW_A from USER_A: <pre><code>SQL> select count(1) from ALL_TAB_PRIVS where grantor = 'USER_A' and PRIVILEGE = 'SELECT' and GRANTEE = 'USER_B'; </code></pre> And now result is: <pre><code> COUNT(1) ---------- 1 </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POOracle DB - how to display privs across schemas/owners?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMartin Mares
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COSorry, the A and B owners are DB owners / schema owners.
 singulars
 PostPostId
 PO
 UserUserId
 USKalamro

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.