Re: Adding a user with SQL Server authentication...

From: jimmers (jimmers@yandex.ru)
Date: 09/27/02 

From: "jimmers" <jimmers@yandex.ru>
Date: Fri, 27 Sep 2002 14:03:34 +0400

This is by design. Next SQL Server version may be more secure
out of the box (http://zdnet.com.com/2100-1104-957376.html)

Cheers
jimmers

"ThomasLL" <ThomasAtTembec@HotMail.cOm> wrote in message
news:8bf701c2656b$752043b0$37ef2ecf@TKMSFTNGXA13...
> Why is it when you create a user, he/she has SELECT
> permissions to sys tables in the default database?
>
> Is this necessary?
>
> Thanks,
> ThomasLL

Relevant Pages

  • Re: How to handle concurrency issue with better performance?
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Then for timestamp, it will be unique? ... Collisions occur because your design permits ... select command). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Privilege-escalation attacks on NT-based Windows are unfixable
    ... Who on earth thinks that the appropriate way to allow a secure service ... of the privileged process to require a particular user interface. ... > Why is this not a serious flaw in the design of the application? ... It can in some cases be a privilege elevation attack, ...
    (comp.security.misc)
  • Re: Privilege-escalation attacks on NT-based Windows are unfixable
    ... Who on earth thinks that the appropriate way to allow a secure service ... of the privileged process to require a particular user interface. ... > Why is this not a serious flaw in the design of the application? ... It can in some cases be a privilege elevation attack, ...
    (comp.os.ms-windows.nt.admin.security)
  • Re: ORDER BY in VIEW not working
    ... As an object-oriented programmer, I expect to be able to encapsulate ... The relevant design principle is that of Orthogonal Design. ... State what version of SQL Server you are using and specify the content ...
    (comp.databases.ms-sqlserver)
  • Re: Target number of database reads per user
    ... Yeah, just to echo what Andy is saying, if you want to have the question ... If you can post code/database design we could all take a look. ... Pro SQL Server 2000 Database Design - ...
    (microsoft.public.sqlserver.programming)