Subject | permission change procedure |
---|---|
Author | Olaf Kluge |
Post date | 2011-05-21T20:17:06Z |
Hello,
I have added a new user on firebird 2.5 database and set some privileges.
All granted procedures can started. But no stored procedures can be changed?
How can I set this privilege on the user?
When I allow a user to change in a table, I must give him all rights in
required procedures where called on trigger and so on. If the trigger insert
the old values in another table, the user also needs the rights for this
table. I would like to separate this. The user should change a record and
should not need rights for changing and executing other objects.
Best regards.
Olaf
[Non-text portions of this message have been removed]
I have added a new user on firebird 2.5 database and set some privileges.
All granted procedures can started. But no stored procedures can be changed?
How can I set this privilege on the user?
When I allow a user to change in a table, I must give him all rights in
required procedures where called on trigger and so on. If the trigger insert
the old values in another table, the user also needs the rights for this
table. I would like to separate this. The user should change a record and
should not need rights for changing and executing other objects.
Best regards.
Olaf
[Non-text portions of this message have been removed]