CODEWITHSUNDEEP
sqlfirebird
Muhammad Waqas
Muhammad Waqas

Reputation: 95

How to grant privileges to a user for any firebird database

I want to GRANT some privileges to a particular user in Firebird like we can do it in MySql as shown below. 

CREATE USER 'user123'@'localhost' IDENTIFIED BY 'user123pass'; 
GRANT CREATE, SELECT, INSERT, DELETE, DROP, UPDATE ON MyTestDb.* TO 'user123'@'localhost';

Is possible in Firebird?

Upvotes: 1

Views: 5419

Answers (1)

Mark Rotteveel
Mark Rotteveel

Reputation: 109264

Unfortunately, this is not possible. You will need to grant privileges per table or view explicitly and individually.

See also the GRANT syntax in the Firebird 2.5 Language Reference and the Firebird 3 release notes

Upvotes: 2

Related Questions