Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-02 : 00:12:55
|
Alec writes "Hi,
I'm developing a SQL Server base system. The system have an administration facilty that will only allow some administrators to manipulate the data base on their permissions granted to them.
The user that will use the administration facility will be created dynamically by the system using a data entry form for entering a user and password plus the roles of the user grants to them.
How can I make this user as a database user with permissions granted like SELECT,UPDATE AND DELETE to tables so that everytime this user opened a connection he/she is limited to what was granted to him.
thanks and I'm 100% hoping for the answer.
alec" |
|
|
|
|
|
URGENT: Dynamic creation of Users with roles