Hi
You can create a SP to grant privileges like:
For select..
Grant ...

Regards
Paul


|-----Original Message-----
|From: firebird-support@yahoogroups.com [mailto:firebird-
|support@yahoogroups.com] On Behalf Of Michael Weissenbacher
|Sent: Tuesday, June 13, 2006 1:11 PM
|To: firebird-support@yahoogroups.com
|Subject: Re: [firebird-support] GRANT ALL TO PUBLIC
|
|Hi,
|> I know, in MySQL there is a possibility to grant all on *.*, which
|> means to grant all privileges to public on every table, view, etc.
|> And I know, there isn't a possibility in FB1.5.
|true, unfortunately the only way is to do a grant statement for every
|view and every table, which can be annoying. with ibexpert for example
|you can simulate it, but there is not direct way to do it. i guess this
|would be a much needed feature, maybe someone should make a feature
|request on sf.net :)
|
|Michael
|
|
|
|++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
|
|Visit http://firebird.sourceforge.net and click the Resources item on
|the main (top) menu. Try Knowledgebase and FAQ links !
|
|Also search the knowledgebases at http://www.ibphoenix.com
|
|++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
|
|Yahoo! Groups Links
|
|
|
|
|