2010/6/24 akp geek <akpgeek@xxxxxxxxx>: > It's not for the user postgres.. If I have created a testuser, can I hide > the code for that testuser? > Regards > you can do it. But mostly of all instruments for postgres will not work corectly - like pgAdmin and others. So this step is usually unwanted. try REVOKE SELECT ON pg_proc FROM public; REVOKE SELECT ON pg_view FROM public; > On Thu, Jun 24, 2010 at 3:42 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> > wrote: >> >> Hello >> >> 2010/6/24 akp geek <akpgeek@xxxxxxxxx>: >> > Hi all - >> > Is there way in postgres to set the user privileges so that >> > when >> > they login , the user can not see functions and views? >> >> you can't do it for user postgres. >> >> Regards >> >> Pavel Stehule >> >> > Regards > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
