Grant permission problem

Question

Grant permission problem

Alexandre Pare

SSC Journeyman

Points: 86
More actions
January 18, 2005 at 9:13 am

#164283

Hi.
Can someone tell me what is the problem with this SQL statement:
GRANT SELECT ON [system_function_schema].[fn_trace_getinfo] TO [Audit]
I'am log on as the system administrator of the SQL Server. When i execute this statement, a get the message : Invalid object name 'system_function_schema.fn_trace_getinfo'.
If i execute this statement on an other server, it works. The two servers have SP3a install on them.
Please help me

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

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

Charles Otten Default port Points: 1475 More actions · Answer 1

It appears either the function fn_trace_getinfo doesn't exist on the server OR the function does exist but system_function_schema isn't the owner/schema name for the function.

c

If the phone doesn't ring...It's me.

Alexandre Pare SSC Journeyman Points: 86 More actions · Answer 2

I try to give access to this function to the user "Audit" using Enterprise Manager and i get the same error message.

Alexandre Pare SSC Journeyman Points: 86 More actions · Answer 3

Thank's to everyone but i find it.

I just need to set the server option 'Allowmodification to be made directly to the system catalogs ' to ON

Alexandre

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 4

Dont forget to turn that OFF. Very bad to modify system and forget that step

Good Hunting!

AJ Ahrens

webmaster@kritter.net