This is a multi-part message in MIME format.
--=_NextPart_000_0020_01C5E53E.B83BB160
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
What do I need to do to give someone access to Manage Triggers in EM?
Is there a way to give them access to view triggers via EM, but disable = their ability to create/drop?
--=_NextPart_000_0020_01C5E53E.B83BB160
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
What do I need to do = to give someone access to Manage Triggers in EM?
Is there a way to give = them access to view triggers via EM, but disable their ability to = create/drop?
--=_NextPart_000_0020_01C5E53E.B83BB160--You need to be table owner or higher for this. And you cannot grant table owner in 2000. In other
words, either be the owner of the table or db_owner (you could try db_ddladmin, not sure). Whether
EM then will enable the option or not, I don't know...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JLS" <jlshoop@.hotmail.com> wrote in message news:eoNMiiW5FHA.620@.TK2MSFTNGP12.phx.gbl...
What do I need to do to give someone access to Manage Triggers in EM?
Is there a way to give them access to view triggers via EM, but disable their ability to
create/drop?
Friday, March 30, 2012
Manage Triggers grayed out
Labels:
_nextpart_000_0020_01c5e53e,
b83bb160,
charset,
content-type,
database,
format,
grayed,
iso-8859-1,
manage,
message,
microsoft,
mime,
multi-part,
mysql,
oracle,
plain,
server,
sql,
text,
triggers
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment