Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot drop the table 'HDB_SCHEDULED_TASKS', because it does not exist or you do not have permission. Expand / Collapse
Author
Message
Posted Wednesday, July 30, 2008 5:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 30, 2008 7:42 AM
Points: 2, Visits: 5
I've installed SQL Server 2005 and intend on using it as the back-end database for Hyperion Financial Management.

The Hyperion application requires a database to be created called "hypdb" which has a user called "hypuser" that has full administrator access, which I've created.

However when I run the Hyperion Configuration Utility which sets up the database for Financial Management application I keep getting a bunch of failures which state:

Cannot drop the table 'HDB_SCHEDULED_TASKS', because it does not exist or you do not have permission.

Cannot drop the table 'hub_metainfo', because it does not exist or you do not have permission.

And so on. I've checked that these tables exist in the database and they do, although I don't know what they are used for.

Has anyone got any ideas why I can't drop them? Is there some kind of permissions setting that is specifically required to drop tables?
Post #543347
Posted Wednesday, July 30, 2008 7:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 30, 2008 7:42 AM
Points: 2, Visits: 5
After days of pondering I've just solved it myself, so I guess this becomes more of an FYI for anyone searching for an answer to this on Google like I was.

I had created the "hypdb" database having logged in using Windows Authentication so therefore with my Windows log in.

I deleted "hypdb" and disconnected from the SQL server, then reconnected again but logged in as "hypuser".

Then created the "hypdb" database again logged in as "hypuser", re-ran the Hyperion Configuration Utlity and was successful.

Appears as though you have to be the database owner to drop tables within it.
Post #543489
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse