Is there a way to grant users to view stored procedures.

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups

DB Engine

SQL Server MSDE SQL Server CE

Services

Analysis (Data Mining)Analysis (OLAP)DTS Integration Services Notification Services Reporting Services

Programming

CLR Connectivity SQL XML

Other Technologies

Clustering English Query Full-Text Search Replication Service Broker

General

Data Warehousing Performance Security Setup SQL Server Tools Other SQL Server Topics

Directory User Groups

Related Topics

MS Access Other DB Products MS Server Products .NET Development VB Development Java Development More Topics ...

SQL Server Forum / Programming / SQL / July 2008

Is there a way to grant users to view stored procedures.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lam Nguyen - 24 Jul 2008 19:08 GMT

Hi,

Does anyone knows if there is a way to grant users view stored procedures.
I am using SQL 2005. Thanks in advance.

I got an errors and not sure if it's the correct syntax:

GRANT VIEW DEFINITION ON SCHENA:dbo TO [CompDomain\BizTlkAdmin]
GO

Reply to this Message

Russell Fields - 24 Jul 2008 19:27 GMT

Lam,

Very close, but a couple of typing errors:

GRANT VIEW DEFINITION ON SCHEMA::dbo TO [CompDomain\BizTlkAdmin]

Notice that there are two ':' characters.

RLF

> Hi,
>
[quoted text clipped - 5 lines]
> GRANT VIEW DEFINITION ON SCHENA:dbo TO [CompDomain\BizTlkAdmin]
> GO

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2009 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.