On Wed, May 19, 2010 at 9:39 AM, mnavahan <mnavahan@xxxxxxxxx> wrote: > > I try to move from firebird to postgresql But it seems some option to do hold > .. > > > 1. In grant section in some reason user ROLE R1 can Access to function F1 > and F1 can access to Table T1 bUT user must not be granted to work directly > to table T1 > > In firebird ,I can invoke grant to object > GRANT SELECT, INSERT ON T1 TO PROCEDURE F1; > > Can I do the same with postgresql or other ways to do this job ? I think so. Look up "SECURITY DEFINER" > 2. In new firebird 2.1.3, I have some "DATABASE TRIGGER" for user to connect > & disconnect or start & finish database or transaction . Do we have same > trigger or any ways in PG to do the same ? Not that I know of. You're talking connect / disconnect triggers right? > 3.I work with pgadmin3 and it is very nice and free ... also I have checked > many other commercial experts such as novicat, pgmanager,maestro.... BUT > I did not find any editor as POWERFUL as IBEXPERT for firebird. > Is there any Powerful editor as powerful as IBEXPERT in PG ? I use nano or vi for most stuff. Both can do color coding quite nicely for .sql files. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
