Re: priviledges newbie

2004-05-05 Thread Fajar Priyanto
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thanks Egor, It works. But it seems that it's not 100% automatically just like unix file permission. The administrator must set it up on each database. So, I give the users CREATE privilege globally, but not DROP. It will prevent them from messing ar

Re: priviledges newbie

2004-05-05 Thread Egor Egorov
Fajar Priyanto <[EMAIL PROTECTED]> wrote: > Hi all, > Can I create a user that can create and drop his database while at the same= > time can not drop databases that are not belong to him? > How do I set this priviledge? If you grant CREATE and DROP privileges on the dbname, it means that user can

priviledges newbie

2004-05-04 Thread Fajar Priyanto
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, Can I create a user that can create and drop his database while at the same time can not drop databases that are not belong to him? How do I set this priviledge? TIA, - -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org 09