Re: Read-Only table?

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


.

Relevant Pages

  • Re: DROP Statement
    ... Some of the create permissions are transferrable but alter ... user needs to be the database owner, a member of sysadmins ... or a member of db_ddladmin. ...
    (microsoft.public.sqlserver.security)
  • Re: DBCC CHECKDB permissions
    ... The user needs to be a member of sysadmins or ... >Still too much power. ... I want to give execute permissions to just DBCC ...
    (microsoft.public.sqlserver.security)
  • RE: copied music cds have a skip in last 18 seconds
    ... If installing all missing Windows Updates doesn't fix your problem ... xiowan.......in tucson ...
    (microsoft.public.windows.mediacenter)