What is the equivalent of DRI in code?

Question

Post reply

What is the equivalent of DRI in code?

shahgols

SSCrazy Eights

Points: 9874
More actions
August 17, 2005 at 4:28 pm

#165226

Hi everyone, I see in EM that one of my users has the DRI right on a table. How do I give her that permission through a GRANT statement?

Viewing 6 posts - 1 through 6 (of 6 total)

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

philcart SSC-Forever Points: 47797 More actions · Answer 1

That would be GRANT REFERENCES.

--------------------
Colt 45 - the original point and click interface

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Is to grant create foreign keys access only or the users can do more than that with this?

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 3

REFERENCES also gives permission to schemabind views or functions against an object. In SQL Server 2005 I believe it will be used for certain uses with CLR code as well.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Ninja's_RGR'us

SSC Guru

Points: 294069

August 18, 2005 at 7:23 am

#583005

Thanks.

shahgols SSCrazy Eights Points: 9874 More actions · Answer 5

shahgols

SSCrazy Eights

Points: 9874

August 18, 2005 at 4:38 pm

#583362

Thank you very much!