Yes, I know, and I apply it.
But when I tried to do it in FB databases, I couldn't find anything about
it.

Grant alter on table table1 ...
or something like that.

Ramiro

2010/5/31 Michael Ludwig <milu71@...>

>
>
> Ramiro Barreca schrieb am 31.05.2010 um 12:32:41 (-0300):
>
> > Is there the possibility to grant DDL permissions to any object for
> > users other than SYSDBA or its owner?
> >
> > I mean, We have several databases that are accessed by developers that
> > must have alter permission to work at development time. But there are
> > only grant to DML sentencies.
>
> It's possible in Oracle and MSSQL and possibly others:
>
> http://technet.microsoft.com/en-us/library/ms178569.aspx
> http://ss64.com/ora/grant.html
>
> Not sure about other systems. In Firebird, it looks like those
> operations are restricted to owner and SYSDBA.
>
> --
> Michael Ludwig
>
>
>

--
Ramiro Barreca
rbarreca@...


[Non-text portions of this message have been removed]