Re: Help understanding Stored proc Level Secuirty? ... Jasper Smith (SQL Server MVP)... I set permissions to my Stored Procedures,... Access to stored procs fail... (microsoft.public.sqlserver.security)
Re: Newbie on permissions: ADO.NET, C++.NET, SQL SERVER 2005 EXPRESS, Visual Studio 2005 ...Permissions are per logins and users. ... permissions can be granted through stored procedures,... an extent a trivial question since I can do programming in VS as ..."Administrator" (it's annoying to switch users using Windows XP Pro, ... (comp.databases.ms-sqlserver)
Re: Newbie: Restrict user account access to stored procedures ... You can deny users permissions to directly access tables and views by adding ...SQL Server does not, to the best of my knowledge, support any database role,...stored procedures.... (microsoft.public.sqlserver.security)
Re: permissions required for executing CDOSys stored procedures ... sysadmin and who has not been granted specific execute permissions on the ... I don't know what version of SQL Server you are using, ...stored procedures within the database that call the sp_OACreate & ... Apparently only members of the sysadmin role can ... (microsoft.public.sqlserver.security)
Re: application roles ... from poolin, the big issue is that they represent a giant security ... because it seems like such a good way to handle database access... >> The best way is to take advantage of parameterized stored procedures,... >> stored procedures and denying all permissions to the base tables to ... (microsoft.public.dotnet.languages.vb)
