Limit the normal user to see system catalog or not??? And create privilege???
| От | leaf_yxj |
|---|---|
| Тема | Limit the normal user to see system catalog or not??? And create privilege??? |
| Дата | |
| Msg-id | 1332953682245-5601146.post@n5.nabble.com обсуждение |
| Ответы |
Re: Limit the normal user to see system catalog or not???
And create privilege???
Re: Limit the normal user to see system catalog or not??? And create privilege??? |
| Список | pgsql-general |
For oracle, the normal user can't see all the system catalog. but for postgresql, it looks like all the user can see the system catalog. Should we limit the user read privilege to system catalog? In oracle, the system privilege has create table, create view,create function. For postgresql database, how to control the user who only can create table but can't create view. Based on the test I did, once the user has the create privilege on the schema, the user will have any create privilege on that schema. In postgresql, Rule is used to control that ??? very confused! Thanks. Regards. Grace -- View this message in context: http://postgresql.1045698.n5.nabble.com/Limit-the-normal-user-to-see-system-catalog-or-not-And-create-privilege-tp5601146p5601146.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
В списке pgsql-general по дате отправления: