Limit the normal user to see system catalog or not??? And create privilege???

From: leaf_yxj <leaf_yxj(at)163(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Limit the normal user to see system catalog or not??? And create privilege???
Date: 2012-03-28 16:54:42
Message-ID: 1332953682245-5601146.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Tilton 2012-03-28 16:54:54 How return a row from a function so it is recognized as such by caller?
Previous Message leaf_yxj 2012-03-28 16:38:09 Re: how postgresql passes the parameter to the function. syntax error near or at "$1".