Re: create a user for app admin

2010-02-26 Thread mos
At 08:56 AM 2/26/2010, Elim PDT wrote: Is there a way to create a user that has full control over a specified database but cannot access any other database at all? that user cannot delete the specified database, cannot create/delete other database, but can do everything within the specified data

Re: create a user for app admin

2010-02-26 Thread Johan De Meersman
Yes, there is. Go and have a look at the documenation for the GRANT statement, and understand what you're doing before executing some command line some random person gives you. 2010/2/26 Elim PDT > Is there a way to create a user that has full control over a specified > database but cannot acc

create a user for app admin

2010-02-26 Thread Elim PDT
Is there a way to create a user that has full control over a specified database but cannot access any other database at all? that user cannot delete the specified database, cannot create/delete other database, but can do everything within the specified database? Thanks for any help.