User/group "public" rights
Hello,
I was wondering what are the rights the user/group "public" has, by default, in a newly created database ?
Best regards,
John
It seems that there is no explicit documentation about this.
But it seems that the "public" user has:
- CONNECT right to the database
- SELECT rights on (some of the) the system tables/system views
I think that the easies way to get your answer is to execute this:
SHOW GRANTS FOR 'public'
...And, of course, all the rights on the newly objects created by itself... :)