Re: Deny Anything to sa Account in SQL Express?



No.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"JohnJohn" <JohnJohn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:88E5AC42-E241-4365-9D82-5D000664A2F3@xxxxxxxxxxxxxxxx
Hello. My client is distributing an application that uses SQL Server 2005
Express and mixed mode authentication. Most, if not all, of our users
will
be installing SQL Server 2005 Express only for our application.

We want to be able to prevent ANY users (including sa) from being able to
select, insert, create tables, views, etc. except through the application.
Is this even possible?

Thanks,
John


.



Relevant Pages

  • Re: Install Windows Patch via GPO
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.windows.group_policy)
  • Re: Trust windows 2k to windows 2k3
    ... This posting is provided "AS-IS" with no warranties or guarantees and ... confers no rights. ... only reply to Newsgroups ...
    (microsoft.public.windows.server.active_directory)
  • Re: Trust windows 2k to windows 2k3
    ... This posting is provided "AS-IS" with no warranties or guarantees and confers no rights. ... only reply to Newsgroups ...
    (microsoft.public.windows.server.active_directory)
  • Re: Installing a 360 Media Center Extender
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.windows.mediacenter)
  • Re: Trust windows 2k to windows 2k3
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... only reply to Newsgroups ...
    (microsoft.public.windows.server.active_directory)