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 |
|
elektrobank
Starting Member
15 Posts |
 Posted - 2003-03-22 : 18:57:38
|
| I have written some code which adds a user login, gives that user access to a specific database and assigns it's roles (datareader, datawriter, ect). The problem I'm having is that when I go to view the permissions on that database, the user I created doesn't have Select/Insert/Update access to any of the tables. This strikes me as odd because I can log in just fine through VB and execute queries just fine as that user, only think I can't do is use that user with programs like Crystal Reports, it doesn't give me access as that user. How can I give that user access to all the tables in a specific database through a stored procedure? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-22 : 20:38:35
|
| You probably need to define a role in the database, give that roelexecute permission on the SPs the add the user to that role.Note that permissions will be validated again on any queries that access other databases so the user will need to be added to a role in that database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Adding users to database