Read only user and not seeing Tables, views etc

I would like to be able to setup a user that can only select information
from a View.
But when I enable security for this user, the user can see all the
tables, Views, Store Proc etc. I know it is only the names, but I don't
want the user to be able to do this, as he is only allowed to view the
view I have enabled for him.
The user can log in using Enterprise Manager and flick through the
tables, views etc, but can't read them, but he can get the names which
is what I don't want to happen.
Is there anyway of stopping the user from seeing all the other
information?
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Hi,
In Enterprise manager you cant control that.
Thanks
Hari
MCDBA
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:ObOG040BEHA.892@.TK2MSFTNGP09.phx.gbl...
> I would like to be able to setup a user that can only select information
> from a View.
> But when I enable security for this user, the user can see all the
> tables, Views, Store Proc etc. I know it is only the names, but I don't
> want the user to be able to do this, as he is only allowed to view the
> view I have enabled for him.
> The user can log in using Enterprise Manager and flick through the
> tables, views etc, but can't read them, but he can get the names which
> is what I don't want to happen.
> Is there anyway of stopping the user from seeing all the other
> information?
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

Read and Delete Mail in SQL 2005

Does anyone have script or a CLR assembly to read and delete email in
SQL2005? I don't want to enable SQL mail or install Outlook.
Thanks in advance
Terry
Hi
You may want to check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncodefun/html/code4fun03282003.asp
John
"Terry" wrote:

> Does anyone have script or a CLR assembly to read and delete email in
> SQL2005? I don't want to enable SQL mail or install Outlook.
> Thanks in advance
> Terry
>

Read and Delete Mail in SQL 2005

Does anyone have script or a CLR assembly to read and delete email in
SQL2005? I don't want to enable SQL mail or install Outlook.
Thanks in advance
TerryHi
You may want to check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncodefun/html/code4fun03282003.asp
John
"Terry" wrote:
> Does anyone have script or a CLR assembly to read and delete email in
> SQL2005? I don't want to enable SQL mail or install Outlook.
> Thanks in advance
> Terry
>

Read and Delete Mail in SQL 2005

Does anyone have script or a CLR assembly to read and delete email in
SQL2005? I don't want to enable SQL mail or install Outlook.
Thanks in advance
TerryHi
You may want to check out
http://msdn.microsoft.com/library/d...fun03282003.asp
John
"Terry" wrote:

> Does anyone have script or a CLR assembly to read and delete email in
> SQL2005? I don't want to enable SQL mail or install Outlook.
> Thanks in advance
> Terry
>