I've got a database called 'tdc' which is used primarily by a user on
the system known as 'tdc'. I think that way back I had created the
database with another user, and now I'm always stuck granting acccess to
both nsadmin AND tdc for every table and sequence, although it would be
great if 'tdc' by default got access to tables created by him.
Current process by user 'tdc':
create table mytable (
id integer
);
grant select, update, delete on mytable to nsadmin;
grant select, update, delete on mytable to tdc;
It's that second grant statement that I'd like to get rid of. How can I
reassign ownership of the entire database, or just give default
permissions on all new tables to 'tdc'?
Thanks,
Dan Chak
--
------------------------------------------------------------------------
dan chak ! 372 memorial drive ! cambridge ma 02139 ! .617.621.1369 x1625
"i'm a good man - i'm just a bad wizard" ! .240.248.8089 fax
------------------------------------------------------------------------
http://www.chak.org slurp.slurp.thwippitt!
