Re: How do I restrict access on tables which were given "public" select ????????????????????????

You can't do that unless you want to write your own security system. This is a half-serious remark, I'm currently working in a situation where they did. If you see what impact it has, you want to remove it immediately. In short, issue a revoke from public and setup more granular security using standard oracle roles.

Hth,

Sybrand Bakker, Oracle DBA

A Ustby wrote in message ...
>How do I restrict access on tables which were given "public" select ????
>
>Thanks for comments.
>
Received on Wed Apr 21 1999 - 12:09:17 CDT