Look at the SQL Reference under the head Authorization ...
Grant SELECT on the tables involved to user One. Also CREATEIN privilege on the schema. This will allow One to create views. Since he is the owner, he can drop only those views (unless he holds any of the higher authorities like DBADM, SYSADM etc)
Originally posted by NNicole
I have a problem with dropping a view.
There is user One that have privileges on select on all tables in Schema1.
I want to give him a prividege to create a view that access tables mentioned above, and also priviledge to drop only views that he creates...
How I can do that?
Thank you in advance
Visit the new-look IDUG Website , register to gain access to the excellent content.