antoedinchar...@gmail.com :

Not enough information.  What version of Firebird are you using?

> I am trying to GRANT edit/recreate procedures for manager level
> users and blocking the same from normal users.

Explain exactly what you mean by "manager level users".

> I was able to do the same in the case of Tables, but for triggers
> and procedures i am not able to limit the modification rights.

Procedures can be modified only by the owner (the user that created the
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

  • [firebird-support] ... antoedinchar...@gmail.com [firebird-support]
    • Re: [firebird-... Helen Borrie hele...@iinet.net.au [firebird-support]
      • Re: [fireb... antoedinchar...@gmail.com [firebird-support]
        • Re: [f... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
          • Re... antoedinchar...@gmail.com [firebird-support]
            • ... Helen Borrie hele...@iinet.net.au [firebird-support]
      • Re: [fireb... antoedinchar...@gmail.com [firebird-support]

Reply via email to