Viewing 15 posts - 151 through 165 (of 251 total)
Another point is in some environments the DBA and the network admin(s) are not
necessarily the same person, and the domain admins are not always given rights
to the SQL...
February 11, 2003 at 12:22 pm
Steve would "UNION ALL" work faster as the hard coded query is not going to produce duplicates?
Tim C.
//Will write code for food
One Windows to rule them all, One Windows to...
February 7, 2003 at 3:07 pm
Brians solution is much cleaner and simpler John. Just finished adding it to my briefcase..
Tim C.
//Will write code for food
One Windows to rule them all, One Windows to find them,
One...
February 7, 2003 at 2:10 pm
I wrote this stored proc to print out the sql to add / remove all check constraints for a db, you could modify it to do what you want.
EXEC...
February 7, 2003 at 12:48 pm
Sorry, ran your query, and too another look at what you were ouputting. You were not displaying just what stored procedures public had access to, but ones that queried or...
February 7, 2003 at 12:25 pm
Brian this does close to the same thing as your query, but does not limit the search to stored procedures, if that was your goal. :
February 7, 2003 at 12:22 pm
Steve J, your article is an excellent compilation of resources about security. I will be assimilating them soon into my heap....
Tim C.
//Will write code for food
One Windows to rule them...
February 7, 2003 at 12:03 pm
Thanks David, but there are too many things I do not understand. I am a nuts and
bolts person, and like to truly understand how the internals of things work....
February 7, 2003 at 8:55 am
Thanks Brian for allaying some of my worries. I am in Davids boat, a developer
who has often had to pull double duty as a DBA. Unlike the DBA wannabe...
February 7, 2003 at 8:11 am
As an alternative, you can use OPENXML to insert multiple rows with one procedure call.
Tim C.
//Will write code for food
One Windows to rule them all, One Windows to find them,
One...
February 4, 2003 at 8:24 am
I am in total agreement with you Brian, I was just trying to state that many
dbas / developers have written procedures that call procedures in master that
public does...
February 3, 2003 at 8:45 am
Script ONE - create the DB and user
CREATE DATABASE [foo] ON (
NAME = N'foo_Data',
FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL\data\foo_Data.MDF' ,
SIZE = 1, FILEGROWTH...
January 31, 2003 at 5:13 pm
Most procedures in master do have public access, but many do not.
Take for example :
sp_helprotect sp_addlogin
GO
sp_helprotect sp_OACreate
GO
sp_helprotect xp_cmdshell
GO
Outputs :
January 31, 2003 at 5:12 pm
Oops, posted my last post before I saw brians reply. Look forward to your article as this is going to have many design implications on databases, more than I can...
January 31, 2003 at 10:36 am
What it does is force you to be more careful with your security. As most
databases are created as dbo, and the owner is typically sa, then the default
rights...
January 31, 2003 at 10:34 am
Viewing 15 posts - 151 through 165 (of 251 total)