Stored procedures not viewable if does not have permissions.

  • Thread starter Thread starter BJ Freeman
  • Start date Start date
B

BJ Freeman

Not sure which Newsgroup this is more appropriate for.
In an ADP if the tables, and View have the public removed, only the persons
with permissions can see them in the ADP.
How do I get the same behavior for Stored procedures.
 
I should have looked at the profiler first.
it is doing a select on the sysobjects table, instead of going thru a proc
that checks permissions, like for tables.
apparently when I did a revoke from public, it does not include system
tables.
remove the public manually. That did the trick.
 
Back
Top