Skip to Content
0
Former Member
Apr 01, 2014 at 08:28 AM

SQL View Privileges

17 Views

Hi all,

we've encountered the following problem:

When creating a view inside one schema with access to tables inside another, only the creator has permission to read its content, even though every one of us has the same privileges on both schemas.

On the other hand, if we create views that access tables in the very same schema, there are no restrictions whatsoever.

Any ideas what might cause the problem?

Regards,

Thomas