All Forums Database
dsearl 1 post Joined 10/04
25 Jan 2006
Grant References...

I need to grant 'references' to user/roles, but I can't figure out how to do the whole database at once. The only way I can find it is the following:grant references on db.table to userIs there a way to grant this on the entire db at once??

TD_Arch 35 posts Joined 07/05
27 Jan 2006

The following statement will grant on the entire db at once:grant references on DB to user;You may consider appending "WITH GRANT OPTION" too.

dnoeth 4628 posts Joined 11/04
27 Jan 2006

Hi TD_Arch,did you try that before? *** Failure 3706 Syntax error: Attempt to grant/revoke REFERENCES on database object.Hi dsearl,sorry, but you can't grant references on a database level.Why do you need reference right, probably not for Foreign Keys, so maybe another right (e.g. checkpoint) would work also?Dieter

Dieter

You must sign in to leave a comment.