Re: Read-Only table?
- From: "Kalen Delaney" <replies@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 22 May 2007 09:33:35 -0700
Other than permissions, which as you know, are ignored for sysadmins, the
only other solution is to create the readonly tables on their own filegroup,
and then mark the filegroup as readonly.
Of course, a sysadmin could change the readonly property, but it would have
to be changed explicitly.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Ron" <Ron@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B8D0D8B9-D4A9-44FD-9729-76B208D9E1F9@xxxxxxxxxxxxxxxx
Is there a simple way to make a table read-only? I know using grants and
roles you can get down to the object level, however the user/login I'm
trying
to restrict has the sa role, which I'm sure overrides everything, making
this
probably a dumb question.
Not being familiar with this application, I'm asking if there's a quick
fix
(read-only table) without the headache that will come with creating grants
for each table.
SQL2000 sp4
Thanks
Ron
.
- Follow-Ups:
- Re: Read-Only table?
- From: Erland Sommarskog
- Re: Read-Only table?
- Prev by Date: Re: SQL 2000 table deleted...
- Next by Date: Re: Public Role for SQL 2000
- Previous by thread: SQL 2000 table deleted...
- Next by thread: Re: Read-Only table?
- Index(es):
Relevant Pages
|
