field level security 
Author Message
 field level security
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.

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 field level security

Quote:

> 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,

Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN
     "I don't suffer from insanity; I enjoy every minute of it!"



Wed, 18 Jun 1902 08:00:00 GMT
 field level security
Views are a useful way of achieving this.
Quote:

> 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.

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Field Level Security

2. Field Level Security

3. field level security

4. Field level security

5. Field level security

6. Field-Level Security

7. field level security control

8. Field Level Security

9. Field Level Security

10. Field Level Security

11. Field level security

12. field level security


 
Powered by phpBB® Forum Software