restrict user access

microsoft.public.sqlserver.tools

24 Jan 2006 4:33 AM

beachboy

how can i set the user access level for sql 2000 server?
i want to restrict the user only can query/add table/ drop table/ modify
data/import & export data
but don't allow them to view other services such as "Management,
Replication, Security...etc"

which standard role i can choose or need to create a custom role for this?

btw, Although user can view the content of other user, but they still can
see the name of DB? how can avoid this?

Thanks in advanced.