Now have a question, is I create a role, this role is only to select a list of specific queries, and then create a new user with only the role,
But now through the users connect to the database, in addition to see this particular table, unexpectedly also can see all the System in the attempt to Views,
Want to ask, how to make them unable to see these System Views, thank you.

CodePudding user response:

As long as you can login to the database of users, the public objects can be seen

CodePudding user response:

reference 1/f, freedom and responsibility of reply:

as long as you can login to the database of users, the public objects can be seen

What can I get rid of the role or the Public attribute of the user

CodePudding user response:

Can revoke get rid of a specific object of public authority in theory, but may cause system can't use, because the public is usually so object accessible,