Re: [SQL] database rights?

On Thu, 24 Feb 2000, Engard Ferenc wrote:

> When I create a table, what depends that I can do it on? And, what
> permissions will be create the new table with?

Only the creator will be able to do anything with the table.

> Ie, I have a database, and I want to access it with two users, and
> one of them can create tables, but the newly created tables should be
> accessed by the other user by default.

GRANT {SELECT|UPDATE|etc} TO other_user;

> And what if I want to create tables with two users in it?

If you mean two owners, you can't.

> With the 'createuser' command it asks whether I want to create a new
> database for the new user, and warns 'don't forget to create a
> database for almafa' if I don't create. How can I do it later, or
> change the owner of a database/table?

I don't know where this idea "one database per user" came from, but most
of the time you don't really want to do that. To create databases, use
CREATE DATABASE.

> As long as I see, the grant/revoke works only for tables... Can I set
> it to rows maybe...? Or should I create views for that?

Not yet and Yes.


-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden