You might ask him what he has been smoking. In Oracle if a user can
create an object then they can grant permissions on that object. What
he is alluding to is the "grant with admin" priviledges that allows one
user to grant access to another users objects. The opposite of what
he's saying. What he is saying IS impossible in Oracle.

Now what you can do in Oracle is imbed the pseudo column 'user'
into the view definitions where clause such that users only see the rows
that pertain to themselves, dynamically.


Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Kermit Lowry
[mailto:db2udbdba-ezmlmshield-x14160910.[Email address protected]
Sent: Tuesday, November 30, 2004 12:17 PM
To: LazyDBA Discussion
Subject: grant permission to create a view but cannot grant permissions
on view to others

I have a gentleman in my IT shop who is trying to grant permissions for
a user to create a view, but not allow that user to grant permission on
that view to someone else. He says you can do this in Oracle with the
"without admin" clause, but we cannot find this functionality in the
documentation we have perused.

If this can be done in udb 8.1.5, could someone please assist?

TIA,
Kermit


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page