Post reply

Grant permission problem

  • January 18, 2005 at 9:16 am

    #74843

    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

  • January 18, 2005 at 9:20 am

    #537866

    use this way. But Iam not sure.

    Use system_function_schema

    go

    GRANT SELECT

    ON fn_trace_getinfo

    TO Audit

    If Audit is a nt group users, you need to specify the domain name also.

    Thanks,

    Ganesh

     

  • January 18, 2005 at 9:52 am

    #537875

    Thank's but it doen't work.

    here the message i get : Could not locate entry in sysdatabases for database 'system_function_schema'. No entry found with that name. Make sure that the name is entered correctly.

    I'am having the same problem if i try to give the access by Enterprise Manager !!

     

  • January 18, 2005 at 10:06 am

    #537882

    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

     

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

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