| Subject | Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure |
|---|---|
| Author | Helen Borrie |
| Post date | 2018-09-27T20:43:03Z |
antoedincharley@... :
Not enough information. What version of Firebird are you using?
procedure) and the SYSDBA or a user with elevated privileges.
Likewise triggers; although the owner in the case of triggers is the
user that created the table (for table-level triggers) or the database
owner (for database-level triggers).
about your environment. There may be more you can do to set up what
you want - it depends on the Firebird version.
HB
---
This email has been checked for viruses by AVG.
https://www.avg.com
Not enough information. What version of Firebird are you using?
> I am trying to GRANT edit/recreate procedures for manager levelExplain exactly what you mean by "manager level users".
> users and blocking the same from normal users.
> I was able to do the same in the case of Tables, but for triggersProcedures can be modified only by the owner (the user that created the
> and procedures i am not able to limit the modification rights.
procedure) and the SYSDBA or a user with elevated privileges.
Likewise triggers; although the owner in the case of triggers is the
user that created the table (for table-level triggers) or the database
owner (for database-level triggers).
> please help me on this.You can help others to help you by providing sufficient information
about your environment. There may be more you can do to set up what
you want - it depends on the Firebird version.
HB
---
This email has been checked for viruses by AVG.
https://www.avg.com