Re: Stored Procs in SQL 2005
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 29 Oct 2007 16:01:51 -0700
Arne Garvander (ArneGarvander@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
How about granting access to tomtenisse at the same time?
What about:
CREATE ROLE nissar
go
EXEC sp_addrolemember nissehult, nissar
EXEC sp_addrolemember tomtenisse, nissar
go
GRANT EXECUTE ON SCHEMA::dbo TO nissar
That is, create a role for each distinct need, and then grant rights to the
role.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Re: Stored Procs in SQL 2005
- From: Erland Sommarskog
- Re: Stored Procs in SQL 2005
- Prev by Date: Roles - Users
- Next by Date: Re: Roles - Users
- Previous by thread: Re: Stored Procs in SQL 2005
- Next by thread: sa account locked out
- Index(es):
