On Thu, Mar 10, 2005 at 09:01:21 -0800, Hemapriya <[EMAIL PROTECTED]> wrote: > Hi, > > Can anybody know how the following statement work. > > Grant ALL on SCHEMA test to user 'user1'; > > will the user be able to have all the privileges on > all the objects/tables on schema test? Or he can only > create new objects in that schema.
That will grant CREATE and USAGE access to the schema, so that the user will be able to look up objects in the schema and create new objects in the schema. It won't change the access rights associated with objects in the schema. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq