Hi Friends,

We have a scenario where there are more than 50 users in a database .
We are loading the database from a database which are having different
set of users.
So after each restoration we have to manually give permissions to all
users which is very hectic.
I thought of a way but unfortunately it's not working . please let me
know where iam missing the track

Following are the steps

use master
go
sp_addlogin suraj,"password",test_db
go
use test_db
go
sp_adduser suraj
go
use master
go
create role special_role
go
use test_db
go
grant all on object1 to special_role
go
use test_db
go
sp_role "grant","special_role",suraj
go


after doing above set of commands i thought iam able to select records
from object1 but it's showing following error

SELECT permission denied on object test, database trial, owner dbo

please let me know the problem

Thanks
suraj

I hit the same problem.
I know a work around for this.. after all the commands
just do "grant null... " that will refreshes all the
caches. and then do select operation.

Hope it may work for you.






suraj_c (AT) hotmail (DOT) com (suraj kumar) wrote in message news:<64719074.0409172353.28a72452 (AT) posting (DOT) google.com>...

Hi,

After u set the roles. do "sp_modifylogin suraj,...." this will
give the access to object1.




amarnadh (AT) iitb (DOT) ac.in (Amarnadh Sai) wrote in message news:<135337d.0409202123.7e5d3aa6 (AT) posting (DOT) google.com>...

Thanks for reply ..

Can You please write the full command.

I didn't get what you are asking me to do

Regards
Suraj