Solved

Database Question

Posted on 2011-03-01
1
1,421 Views
Last Modified: 2012-05-11
Hi,

Suppose user A, who has all authorizations on a relation r, grants select on relation r to public with grant option. Suppose user B then grants select on r to A. Does this cause a cycle in the authorization graph.
0
Comment
Question by:new_perl_user
1 Comment
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 35008438
A will have 2 or 3 grants on the same object or role, and there is no conflict there

the original "all authorizations"
the public grant
the specific grant from B

if the original "all" are direct grants then the grant from B will have no net effect,
so only 2 grants total on r

if the original "all" were through a role, then  A will have 3 grants on r

againl in either case, no conflict


0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

820 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