Basic security issue/test

Question

Basic security issue/test

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

dmoldovan SSCertifiable Points: 6334 More actions · Answer 1

GRANT the DWH role the rights on the tables you need. Or use stored procedures to access the data and grant the EXECUTE right on these procedures.

See http://msdn.microsoft.com/en-us/library/ms187965.aspx

Greg Charles SSC-Forever Points: 45403 More actions · Answer 2

Just to verify: did you make the user a member of the role?

Greg

Jason Coleman SSCrazy Points: 2187 More actions · Answer 3

yep.....made the user a member of the role.

I actually got around the problem temporarily by making the role the owner of the schema that I wanted them to access. Then they could view the tables within that schema.

However that's not ideal, as I don't want them to be the owner, just to have access right to be able to select / insert data.

So how to I not make them the owner, but, grant them access rights to do the above... ?:ermm:

Steve Jones - SSC Editor SSC Guru Points: 739542 More actions · Answer 4

I'm not sure what you did in the tool, but these are simple statements you'd use.

grant select on (table) to DWH

grant insert in (table) to DWH

That's it. If it's not working, perhaps this user is member of another role that has DENY?