Taken from the newsgroup: Ingmar asked:
asked 02 Mar '11, 14:18
Well, each user is member of the PUBLIC group by default, and as such each user can query the system catalog.
You can do the following to restrict that access (tested on SA 12 demo):
Now you can connect as that user "MyUser":
Note: You don't have access to the system catalog, so the following queries will fail with a "permission denied" error:
nor can you access any other table/view/procedure, but you can do the following (with a necessary table owner qualification!):
answered 02 Mar '11, 14:36