grant database roles to read-only specified schema

		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 / General / Security / November 2008

grant database roles to read-only specified schema

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sg - 21 Nov 2008 18:35 GMT

Hi,

I'm trying to grant a database roles (contract_role) to have "select" to the
tables within schema1. Is there a way that I can grant select on all of the
tables to contract_role instead of choosing one by one and click?

Thanks
Sarah

Reply to this Message

Russell Fields - 21 Nov 2008 18:50 GMT

Sarah,

GRANT SELECT ON SCHEMA :: schema1 TO contract_role

RLF

> Hi,
>
[quoted text clipped - 6 lines]
> Thanks
> Sarah

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

©2010 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.