Alan McDonald wrote:

> > Hi All,
> >
> > Is there an easy way to grant a user ALL priviledges for all objects
> > (tables, view, store procedures, etc.) within a database? Having to
> > grant priviledges to each object individually can be quite a chore on
> > a complex database.
> >
> > Thanks,
> > Steve
>
> eacht time you create an object, grant priveleges for it to a role you
> have
> created.
> Then each time you create a user, grant that user the role privelege.
> Alan
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support>" on the web.
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------------------------------------------------
>

and be sure to add the role to your connection statement.