db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: In Derby SQL Authorization, is drop view the only way to drop a view created by a dba? Will revoke privilege ever drop such a view?
Date Wed, 02 Aug 2006 20:04:28 GMT
Mamta Satoor wrote:

> I have been thinking about some view testing and wrote a test case where
> the
> dba creates a view in a schema owned by some other user and the view is
> accessing objects from couple different schemas on which the view's schema
> owner doesn't have access to. The view creation from dba doesn't fail
> because dba can access any object in any schema and can create any
> object in
> any schema. 

Is that true, namely "because dba can access any object in any schema
and can create any object in any schema"?

I could see that being the case, but I don't see that in the functional
spec for grant/revoke.

And are we calling this user the "DBA" or the "database owner"?

Dan.


Mime
View raw message