Re: Views - theory and practice in a multi-schema environment

Hello..

how about this scenario:

create a view in the owner schema.
grant access to users on the view.
(this way users do not need access to the objects.)

create a synonym in the users schema pointing to the view.
(users have the same synonym name to access the same view
   , thus same code can be used across schema's.)

Craig. Received on Wed Nov 06 2002 - 18:28:21 CET