Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set permissions using variables

Status
Not open for further replies.
katehol

katehol

Technical User
May 2, 2007
57
GB
Is there any way that I can set up permissions on SQL Server 2005 with the use of variables. I am looking to do something like this...

Code: 
DECLARE @Login varchar(255)

SET @Login = 'LoginName'

GRANT CONNECT TO QUOTENAME(@Login)
                         --(ie GRANT CONNECT TO [LoginName])

As I have a very long list of permissions, it would save me having to change the login name for each permission.

Any help would be much appreciated.

Thanks

 
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
705
Mike Lewis
Mike Lewis
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
399
Auguy
Auguy
Ikatiemarie
  • Locked
  • Question
Sp_send_dbmail permissions issue
Replies
0
Views
274
Ikatiemarie
Ikatiemarie
Niki_S
  • Locked
  • Question
Create view using two databases
Replies
4
Views
422
Chris Miller
Chris Miller
EM1107
  • Locked
  • Question
Copy folder and content using SQL Server TSQL.
Replies
6
Views
585
RobertPhillips
RobertPhillips

Part and Inventory Search

Sponsor

Back
Top