Обсуждение: permissions on databases

Hi all,

I am the super user of my DBMS and if create a database for a simple user,
I do :

=> create database formyuser;

But If this user connects to the database and tries to create a table, he
has no rights. I must (the super user) create the table for him and then
give him all the permissions with GRANT.

So my question is : How can I create a database for a simple user (ie not
super user) and give him all the rigths to create and drop tables in it ?

Thanks in advance for your answer

Lionel

On Tue, 6 Feb 2001, Tressens Lionel wrote:

> I am the super user of my DBMS and if create a database for a simple user,
> I do :
>
> => create database formyuser;
>
> But If this user connects to the database and tries to create a table, he
> has no rights. I must (the super user) create the table for him and then
> give him all the permissions with GRANT.
>
> So my question is : How can I create a database for a simple user (ie not
> super user) and give him all the rigths to create and drop tables in it ?

Create the user with database create permission and then let the user
create the database directly, so they are the default owner for it.

Otherwise, yes, you need to grant all of the permission to the user.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Whenever people agree with me, I always think I must be wrong.
- Oscar Wilde