Home > Archive > MS SQL Server New Users > April 2005 > right in Enterprise Manager









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author right in Enterprise Manager
isabca

2005-04-26, 8:23 pm

Hi,

In Enterprise Manager, I want some user to have access in all the DTS but i
don't want them to access table in the database. Can I do something like
that.

thank you
--
isabca:)
Anith Sen

2005-04-28, 1:26 pm

Not specifically in EM. However you can explicitly use DENY statement for
the user to prevent access to the tables.

--
Anith


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com