Re: nonsense from Oracle 9i Database Concepts

In article <Jjmq9.27532$uF6.44485_at_rwcrnsc52.ops.asp.att.net>, Michael J. Moore <hicamel_x_the_spam_at_attbi.com> writes:
>Would somebody be kind enough to tell me what this excerpt from
>
>"Oracle 9i Database Concepts" page 15-7 means?
>
>----------------------------------------------------------------------
>
>Security Authorizations
>
>Oracle notices when a DML object or system privilege is granted to or
>revoked from
>
>a user or PUBLIC and automatically invalidates all the owner's dependent
>objects.
>
>Oracle invalidates the dependent objects to verify that an owner of a
>dependent
>
>object continues to have the necessary privileges for all referenced
>objects.
>
>-------------------------------------------------------------
>
>An example would probably help.
>
>Thanks,
>
>Mike
>

Bob grants Mike access to his emp table via: grant select on emp to Bob;

Bob writes a view, emp_date, that joins Bob's emp to his dept table. Mike learns Bob is leaving the company and going to work for a recruting firm so he revokes Bob's access to emp.

Oracle marks the view, emp_date, invalid as necessary privileges do not exist to support use of the view.

HTH -- Mark D Powell --

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net