Information générale
Forum:
Microsoft SQL Server
Hello Kirk,
I think previously you were using sa for login to the server.
It is a good practice to create a group and assign the rights to execute, select, insert, update, delete on all the objects to that group.
Creation of group and assigning the rights can be done through enterprise manager or by using following commands:
sp_addgroup 'myGroupName'
grant grant_option[, ...] on object_name to 'myGroupName'.
This is a one time job.
Later, through your application you can add user to a particular group.
sp_adduser 'existing sql login', 'new user name', 'myGroupName'
While exiting from the application you can again drop this user by using sp_dropuser 'new user name'
---
Raj
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement