RE: permissions to sysobjects

[cags]

I am trying to put a reference contraint to a feild in sysobjects from one of my user tables. I have tried grant references on sysobjects to username in Query Analyzer whilst connected as sa but it just says that granted priveldge REFERENCES is not compatible with this object.
Anyone know how to do this?

 

[cdukes]

Which field are you trying to create a constraint on in sysobjects as many of the fields in the sysobjects table are calculated fields which you cannot create a constarint against.

Chris Dukes

 

[cags]

hi
thanks for responding.
It is the ID field I am trying to get at.

 

[cdukes]

Microsoft DO NOT advise using system tables as foreign keys into user tables as they reserve the right to change system tables between releases. Also ID's kept in system tables are Server/database specfic so that if you need to create a new database or move servers, your foreign keys are no longer correct.

After checking SQL Books on line you will find the following:

The REFERENCES permission cannot be granted for a system table.


Hope this helps,

Chris Dukes