Hide views, sp and functions

[Jose Perdigao]

I have an ADP (acc2003 vs SQL server 2000).

When I open the ADP, nobody can see the tables, views, sp and functions. F11
is not enabling.

But from enterprise manager, we can see all tables, views, sp and functions.



Question:

Is it possible to hide definitely these objects? There is a way to transform
in script and hide them?



Thanks

Jose

 

[Vadim Rapp]

Hello Jose,
You wrote in conference microsoft.public.access.adp.sqlserver on Fri, 3 Feb
2006 17:27:26 +0100:

JP> I have an ADP (acc2003 vs SQL server 2000).

JP> When I open the ADP, nobody can see the tables, views, sp and
JP> functions. F11 is not enabling.

JP> But from enterprise manager, we can see all tables, views, sp and
JP> functions.

Most likely, ADP is connecting with different logon, which does not have the
permission for these tables etc. Another possibility is that ADP is not
connected to the database at all, and connects at run-time.

JP> Question:

JP> Is it possible to hide definitely these objects?

No.

JP> There is a way to transform in script and hide them?

No.


Vadim Rapp

 

[Jose Perdigao]

Thanks Vadim,

If you say no, it means is absolutely true,

From ADP, I can hide. The users can not have access

 

[Vadim Rapp]

JP> If you say no, it means is absolutely true,

And if I say "no" to this statement as well, it will be nice logical
paradox, isn't it

Vadim