Re: permission problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

These are server roles. You have to create on the specific database you are talking about. Check "CREATE ROLE" topic on BOL

--
-----------------------------
"Caminar sobre el agua y desarrollar software a partir de unas
especificaciones es fácil, si ambas están congeladas."
Edward V. Berard, ingeniero informático

http://blogs.solidq.com/es/elrincondeldba


"André Freitas" <thevirus@xxxxxxxxxx> wrote in message news:%235%23fVVpGKHA.1988@xxxxxxxxxxxxxxxxxxxxxxx
can you describe the process more precisily, i tried to do that, but i didnt find the right place to set the exec role permission, i only get this options in creation roles:

bulkadmin
dbcreator
diskadmin
processadmin
public
securityadmin
serveradmin
setupadmin
sysadmin

thx again.

"Carlos Sacristan" <nomail@xxxxxxxxxx> wrote in message news:O4VmfQpGKHA.4376@xxxxxxxxxxxxxxxxxxxxxxx
Create a role that has only EXEC permission on store procedures you want and set this new role to this user, or directly assign those EXEC permission to the user... That's all...

--
-----------------------------
"Caminar sobre el agua y desarrollar software a partir de unas
especificaciones es fácil, si ambas están congeladas."
Edward V. Berard, ingeniero informático

http://blogs.solidq.com/es/elrincondeldba


"André Freitas" <thevirus@xxxxxxxxxx> wrote in message news:%23psW9NpGKHA.1272@xxxxxxxxxxxxxxxxxxxxxxx
is possible to allow a user to run only procedures in a specific database? disabling access to modify or view tables, or to use query's in query analizer?



.

Relevant Pages

  • Re: permission problem
    ... "Carlos Sacristan" wrote in message ... "Caminar sobre el agua y desarrollar software a partir de unas ...
    (microsoft.public.sqlserver.programming)
  • Re: Remove SQL Server 2005 Express Instance ?
    ... "Caminar sobre el agua y desarrollar software a partir de unas ... Edward V. Berard, ingeniero informático ...
    (microsoft.public.sqlserver.server)
  • RE: Security Problem with AD Group in SQL Server Security Logins area
    ... Second problem - if I uncheck that Server Role and leave all the Server Roles ... I can use the Database Access tab to configure who has access to the ... I see dbo ...
    (microsoft.public.sqlserver.security)
  • Re: What commands can a user execute
    ... mapped to any server roles but is a db_owner in almost all databases. ... just learned from a security monitoring script which logs security ... events that a member from this NT Group created and dropped a database. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)
  • Re: mssql date programming
    ... This kind of things is responsibility of the client app. ... take a look on "CAST and CONVERT" BOL's topic. ... "Caminar sobre el agua y desarrollar software a partir de unas ...
    (microsoft.public.sqlserver.programming)