RE: Data access permission?
От | Carlos Felipe Zirbes |
---|---|
Тема | RE: Data access permission? |
Дата | |
Msg-id | 2BE4F32E01B1D411AC93000629133C7F27972E@MAIL01-BR2 обсуждение исходный текст |
Ответ на | Data access permission? (Pluto <pluto@annoyance.net>) |
Список | pgsql-general |
If he wants to restrict access to certains rows, he could create views on those tables containing only the desired rows and then grant access in that view to the correspondent user. Of course, he would have to create a view to each user, but that would be no worse than manually grant/revoke access to rows (if that were possible). Carlos Felipe Zirbes DBServer Assessoria em Sistemas de Informação E-mail: carlosz@dbserver.com.br Fone: (51) 342-8055 / (51) 378-9056 Fax: (51) 342-4838 -----Original Message----- From: Manuel Sugawara [mailto:masm@fciencias.unam.mx] Sent: sexta-feira, 30 de março de 2001 15:21 To: Pluto Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Data access permission? Pluto <pluto@annoyance.net> writes: > Dear all > > Can PostgreSQL, MySQL or other database programs can allow some user to > access some specific data while other data is prohibited to them in a > same database? If so, how to implement that? For instance, a client can > print last month's statement through the Internet by providing a > password to him/her; this client can only check the data that belong to > him/her, at the meantime, there is other clients' data in the same > database. Thanks for your kind help! I don't understand very well the idea. If you want to restrict user access per table you can do it using the commands grant/revoke; however if you want to restrict user access per row; I'm afraid this is not possible, at least not without triggers or rules. Regards, Manuel. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
В списке pgsql-general по дате отправления: