RE: What was that security again?

nt: Thursday, November 18, 2010 3:42 PM To: cf-talk Subject: Re: What was that security again? None of the server or database roles would classify as "minimum settings." You achieve minimum settings with GRANT and DENY statements. Is your goal to restrict a user to only reading data? If

Re: What was that security again?

gleaf.com] > Sent: 18 November 2010 19:20 > To: cf-talk > Subject: Re: What was that security again? > > >> DDLADMIN should suffice, this is what role we give to all our customers. > > That's way more than needed for reading data. > > Dave Watts, CTO, Fig L

RE: What was that security again?

Yes but it is a safe role, you can;t do anything dodgy -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 18 November 2010 19:20 To: cf-talk Subject: Re: What was that security again? > DDLADMIN should suffice, this is what role we give to all our customers. Tha

Re: What was that security again?

> DDLADMIN should suffice, this is what role we give to all our customers. That's way more than needed for reading data. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provid

Re: What was that security again?

> Kinda.. Are there any particular SERVER ROLES or Database Role Membership? Nope. Although db_datareader is basically a shortcut to granting SELECT and EXECUTE. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Bu

Re: What was that security again?

I don't think any Server roles are needed, but "db_datareader" Database role should provide the SELECT permissions. I'm not sure about the permissions for stored procedures. Carl >Kinda.. Are there any particular SERVER ROLES or Database Role Membership? > >Thanks! > >GRANT SELECT >GRANT EXEC

RE: What was that security again?

DDLADMIN should suffice, this is what role we give to all our customers. -- Russ Michaels http://www.bluethunderinternet.com : B2B hosting, VPS's, Exchange, CF, Railo www.cfmldeveloper.com : CFML community, FREE ColdFusion/Railo hosting http://www.michaels.me.uk : My Blog

RE: What was that security again?

Kinda.. Are there any particular SERVER ROLES or Database Role Membership? Thanks! -Original Message- From: Mike Chabot [mailto:mcha...@gmail.com] Sent: Thursday, November 18, 2010 11:42 AM To: cf-talk Subject: Re: What was that security again? GRANT SELECT GRANT EXECUTE Is that

Re: What was that security again?

GRANT SELECT GRANT EXECUTE Is that what you are looking for? -Mike Chabot On Thu, Nov 18, 2010 at 11:32 AM, Brian Polackoff wrote: > > I admit this question is a touch off topic, but the SQL list is not nearly > as active. Can anyone tell me what the minimum MS SQL server 2005 security > setti

What was that security again?

I admit this question is a touch off topic, but the SQL list is not nearly as active. Can anyone tell me what the minimum MS SQL server 2005 security settings to run SELECT and Execute Existing Stored Procedures? My googling has failed me. (it was bound to happen eventually) Thanks! Brian