Re: field level security
Posted in 2000
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)
tcosta@my-deja.com wrote:
> Is it possible to secure fields in an otherwise commonly used table.
> In this case we would just like to hide the data from most users.
RTFM? GRANT/REVOKE?
REVOKE ALL ON SomeTable FROM PUBLIC;
GRANT SELECT(Col01, Col03, Col09) ON SomeTable TO PUBLIC;
--
Yours,
Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h>
Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN
"I don't suffer from insanity; I enjoy every minute of it!"