Re: SQL 2005 execute permissions
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Sun, 17 Dec 2006 09:24:13 +0200
Vern
If the user has a permission to create an object ( he is an owner). As an
owner the user has automatically permission to execute it
"Vern Rabe" <VernRabe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5C52D024-1D3B-4DA0-9924-CDE5B35B2FC1@xxxxxxxxxxxxxxxx
That is what we have now, but it only applies to existing procedures. We
need
to allow a user to create a new procedure and then grant execute
permissions
on it. Am I missing something?
Vern
"jebuskrust@xxxxxxxxx" wrote:
Create a role in the database.. under Security->Roles
Add users the the role while creating it or once its created in the
roles General Properties
Add the role just created to the procedure's permissions
Grant execute permissions for that role for that procedure.. and see if
you have the same problem with the users that are trying to execute
that proc who have that particular role.
Vern Rabe wrote:
In SQL Server 2005, we have users that are not in the db_owner role. We
have
granted permission to create stored procedures in the dbo schema, but
once
created, the user doesn't have permission to GRANT EXEC permission. How
can
that be accomplished?
Thanks
Vern Rabe
.
- References:
- Re: SQL 2005 execute permissions
- From: jebuskrust@xxxxxxxxx
- Re: SQL 2005 execute permissions
- Prev by Date: Login failed for user 'sa'
- Next by Date: Re: system account for sql2005
- Previous by thread: Re: SQL 2005 execute permissions
- Next by thread: Re: Howto give users permission to create tables, but deny them DROP?
- Index(es):
Relevant Pages
|
