pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
database rights? 2+ messages / 2 participants [nested] [flat]
* database rights? @ 2000-02-24 08:13 Engard Ferenc <fery@pons.sote.hu> 0 siblings, 1 reply; 2+ messages in thread From: Engard Ferenc @ 2000-02-24 08:13 UTC (permalink / raw) To: pgsql-sql Hi all, When I create a table, what depends that I can do it on? And, what permissions will be create the new table with? 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. And what if I want to create tables with two users in it? 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? 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? Thanks: Circum -- Need more drivers for linux! -- http://www.libranet.com/petition.html __ @ / \ _ _ Engárd Ferenc l | ( \ / | | (\/) mailto:s-fery@kkt.sote.hu \__/ | | \_ \_/ I I http://pons.sote.hu/~s-fery ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] database rights? @ 2000-02-24 16:21 Peter Eisentraut <e99re41@DoCS.UU.SE> parent: Engard Ferenc <fery@pons.sote.hu> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2000-02-24 16:21 UTC (permalink / raw) To: s-fery@kkt.sote.hu; +Cc: pgsql-sql 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-02-24 16:21 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-02-24 08:13 database rights? Engard Ferenc <fery@pons.sote.hu> 2000-02-24 16:21 ` Peter Eisentraut <e99re41@DoCS.UU.SE>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox