As long as a user has 'n valid login, they can access the tables by any means - Enterprise manager, QueryAnalyser, VisualStudio.NET... etc...

Not sure what you mean by 'sql registrations'... are you talking about the servers you can register in enterprise manager? Remember, enterprise manger is just a client tool to administrate sql server, if a user has rights to access a server, he/she can register that server in EM to be able to administrate/develop in it...

-----Original Message-----
From: luis [mailto:mssqldba-ezmlmshield-x25332557.[Email address protected]
Sent: Wednesday, March 30, 2005 15:53 PM
To: LazyDBA Discussion
Subject: acccess to database view

Hi experts,

how can I provide access to viewing of tables, other than through
enterprise manager to a developer?

Can I restrict what someone can add in terms of sql registrations? Can I
create a read only view?

Thnks,
Luis



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



MS Sql Server LazyDBA home page