GRANT UPDATE (col1, col2, col3) ON TABLE tablename TO user/role

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."




I checked the Language Reference but I don't see that it is possibe to grant
UPDATE priviliges only to columns.
Can you give me the side or a little example?

> Only grant UPDATE priviliges to those two columns.
>
> Check the Language Reference for more.
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
>
>
> >
> > Hi,
> >
> > how can I accomplis that a role can only update two fields in a detail
> > table?
> > It seems to be a problem with the foreign key.
> >
> > Thanks in advance
> >
> > Jörg Schiemann

Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.