Re: How to revoke write, update access from public role
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 04/30/04
- Previous message: Hong: "How to revoke write, update access from public role"
- In reply to: Hong: "How to revoke write, update access from public role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 30 Apr 2004 20:51:05 +0530
Hi
Execute the following in Query Analyzer with text result (Query menu click
result in text) and copy and paste results
to give you the required script.
select 'revoke all on ' + QUOTENAME(name) + ' from [public]'
from sysobjects where type in('U','P','V','TR','IF','FN')
and objectproperty(id,'IsMSShipped')=0
go
Tahnks
Hari
MCDBA
"Hong" <anonymous@discussions.microsoft.com> wrote in message
news:41AE885E-A0CB-4542-B6A9-843454B33A66@microsoft.com...
> Hi,
>
> I have an application that gives all the write, update access to public
role, how could I quickly revoke all the Write and Update access from
Public, instead of uncheck all the checked boxes?
>
> Thanks.
- Previous message: Hong: "How to revoke write, update access from public role"
- In reply to: Hong: "How to revoke write, update access from public role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
