Subject Re: [ib-support] Problem in Check constraints and in Grant Option
Author Claudio Valderrama C.
"jyotindra bhoyania" <jyotindra_bhoyania@...> wrote in message
> Hi All,
> I am using Firebird version and I
> have a very strange.
> Which are as follows
> 1. I Can not drop check CONSTRAINT for particular
> column.

What is the full DROP command? What is the error message?

> 2. I want to grant ALL
> prievilage(ALL,SELECT,UPDATE,...) to ALL TABLE which
> belongs to one database.

You can grant ALL on each table to a user or a role.
You can't grant to on all tables with one command. You should issue the
command for every table. There are utilities that manage rights, have a look

> 3.How to assign a Role to a User for All Tables which
> belongs to one database.

Please read LangRef = Language Reference, one of the guides available in PDF
format. You grant all rights you want to the role, then you grant the role
to any user you want to have that rights. For this to work, you should
specify the role at connection time.

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing