Permissions on a View
Posted in 2006
Chris S — — source: Usenet: comp.databases.informix
Here's a snippet from the Informix 10 Manual: "When you create a view, PUBLIC does not automatically receive any privileges for a view that you create. Only you have access to table data through that view. Even users who have privileges on the base table of the view do not automatically receive privileges for the view." Does this hold true for other DBA's on the same database? It seems as this is the case through some testing I have done here but it seems odd to me. If I do not explicity grant SELECT on my view to a DBA user, then they cannot select from it. Can anyone tell me if this is working as it's supposed to? It seems strange to me that DBA's don't just get full permissions by default on new views.