|
help
Login
|
Register
vmonpara
's code bookmark
Tag:
permission
→ view
all
Tags
ASP .Net
SQL Server
General
InfoPath
javascript
Tag: permission
« previous | next »
Give permission to SQL Server DB user using command line
On 13th Aug, 07 | Topic:
SQL Server
| Tags:
permission
osql -E -S "mycomputer\instance" -Q "sp_grantlogin 'mycomputer\ASPNET'"
osql -E -S "mycomputer\instance" -d dbname -Q "sp_grantdbaccess 'mycomputer\ASPNET'"
osql -E -S "mycomputer\instance" -d dbname -Q "sp_addrolemember 'db_owner', 'mycomputer\ASPNET'"
« previous | next »
| 
Tags
