Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Unanswered: [Help] EXECUTE permission denied on object

    Microsoft OLE DB Provider for SQL Server error '80040e09'

    EXECUTE permission denied on object 'wwfSpTimeAndDateSettings', database 'iobmi6_ETSasp', owner 'dbo'.

    /forum/functions/functions_date_time_format.asp, line 82
    What does the
    EXECUTE permission denied on object...
    line mean?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    It means that the object owner decided NOT to run the following statement:

    grant execute on dbo.wwfSpTimeAndDateSettings to <you>
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Dec 2004
    Posts
    2
    Ok i spent time trying to figure out how to fix it bymyself... but i have no idea. I'm trying to install Iportal... so i remade sure i installed all the files completly. Looked up my database info to see that correct. Is it somthing with my database not having dbo autority? (cause then i'll need to ask my hosting for it)

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What is the User ID specified in the connection string? Issue the statement from the previous post and replace <you> with that value.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Apr 2004
    Location
    LA, CA
    Posts
    125
    Dude! did you read rdjabarob post? if yes, read it again .. if you still don't get it, then I suggest you do some BOL reading about "permissions-SQL Server: Managing permissions"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •