Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Granting Privileges with a Script
Message
From
14/09/2005 06:57:13
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Security
Title:
Granting Privileges with a Script
Miscellaneous
Thread ID:
01049345
Message ID:
01049345
Views:
60
Hi,

I'm trying to write a script to grant privileges to a user (we are trying to allow Windows Authentication in our application).

Previously, we used the following syntax:

grant select, insert, delete, update on area to mattuser

Where mattuser is a valid sql server user.

However, we want to do something like the following:

grant select, insert, delete, update on area to MATT2000\IUSR_MATT2000

Where IUSR_MATT2000 is a valid user on computer MATT2000.

We get an error when we try to run this script as follows:

Incorrect syntax near '\'

How do we grant permissions for this user, other than doing it manually?

Regards.

Matt.
Next
Reply
Map
View

Click here to load this message in the networking platform