Security settings
От | Armbrust, Daniel C. |
---|---|
Тема | Security settings |
Дата | |
Msg-id | 818623B5FD23D51193200002B32C076106FE4E34@excsrv44.mayo.edu обсуждение исходный текст |
Список | pgadmin-support |
I've managed to mess up the permissions on all of the tables in one of my databases.... One way or another. I'm not sureof the actual sequence of events, but I think that a user of the database got deleted, while it was set as having privilegeson these tables. Ever since then, things have been not quite right. When I try to open the properties pane in pgadmin 2, I get the following error: -- Error Information -- Description: Element not found Number: 35601 Routine: pgAdmin II:frmTable.Initialise And then I can continue, but it doesn't show me any of the assigned security info for the table. At the command line, here are the permissions: plesionym-# \dp Access privileges for database "plesionym"Schema | Table | Access privileges --------+-------------------------------+-------------------public | mtstb_plesmnt_context | {=,mirpub=r}public |mtstb_plesmnt_edit_session | {=,mirpub=r}public | mtstb_plesmnt_phrase | {=,mirpub=r}public | mtstb_plesmnt_phrase_relation| {=,mirpub=r}public | mtstb_plesmnt_phrase_type | {=,mirpub=r}public | mtstb_plesmnt_source | {=,mirpub=r} If I try to do the same thing in pgadmin 3 I don't get any errors, and it shows me the proper security. However, I do getan error here if I try to change any of the security settings. I get "ERROR: parser: parser error at or near "ALL" at character 58" Can someone give me an idea of how to fix this? Thanks, Dan
В списке pgadmin-support по дате отправления: