Home Home
  login

Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




permissions error

desktop
add-ons

SELECT permission denied on object 'geminiappsettings', database 'Gemini', owner 'Gemini'.


Ok,. this look like quite a straight forward error. But i can assure you that " select " is allowed on the 'geminiappsettings' table.  I've enclosed the rest the of error log. This line i have a feeling will point me the right direction. Thanks. Anthony 
[ADOException: could not execute query[SQL: SELECT this.settingid as settingid340, this.settingname as settingn2340, this.settingcategory as settingc3340, this.settingvalue as settingv4340, this.settingdesc as settingd5340, this.tstamp as tstamp340 FROM geminiappsettings this_ WHERE this.settingname = ?]]



[SqlException (0x80131904): SELECT permission denied on object 'geminiappsettings', database 'Gemini', owner 'Gemini'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857306
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734918
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
   System.Data.SqlClient.SqlDataReader.getMetaData() +62
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +9
   NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) +112
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) +271
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +280
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +83
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +62

[ADOException: could not execute query[SQL: SELECT this.settingid as settingid340, this.settingname as settingn2340, this.settingcategory as settingc3340, this.settingvalue as settingv4340, this.settingdesc as settingd5340, this.tstamp as tstamp340 FROM geminiappsettings this_ WHERE this.settingname = ?]]
   CounterSoft.Gemini.DataProvider.BaseProvider.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +469
   CounterSoft.Gemini.DataProvider.BaseProvider.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +14
   CounterSoft.Gemini.DataProvider.ApplicationSettingsProvider.x1a95834709519378(String x2335cd6458013014) +89
   CounterSoft.Gemini.Business.DatabaseApplicationSettings.Initialise() +1565
   CounterSoft.Gemini.Business.DatabaseApplicationSettings..ctor() +48
   CounterSoft.Gemini.Business.Initialiser..cctor() +20

[TypeInitializationException: The type initializer for 'Initialiser' threw an exception.]
   CounterSoft.Gemini.Business.DatabaseApplicationSettings.getGetInstance() +14
   CounterSoft.Gemini.Business.ApplicationSettingsFactory.GetAppSettings() +5
   CounterSoft.Gemini.Business.ApplicationSettings..cctor() +5

[TypeInitializationException: The type initializer for 'CounterSoft.Gemini.Business.ApplicationSettings' threw an exception.]
   CounterSoft.Gemini.Business.ApplicationSettings.getShowUserRegistrationLink() +0
   CounterSoft.Gemini.Default.PageLoad(Object sender, EventArgs e) +285
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
anthonyplanet
· 1 		anthonyplanet
Thursday, May 24, 2007, 7:18:42 PM
Replies (7)
helpful
0
not helpful

Looks like you are using SQL authentication, is that correct?

Please check the owner of the table.
Saar Cohen
· 5000 		Saar Cohen
Thursday, May 24, 2007, 10:15:35 PM
helpful
0
not helpful

Table geminiappsettings is definately owned by user Gemini and has "select" selected in the permissions.

My instinct is this part of the error might have the answers

FROM geminiappsettings this_ WHERE this_.settingname = ?]]

anymore thoughts, would be much appreciated. 

thanks for the response.

ps, this is for the webapp not the desktop. sorry i've put this post in the wrong place


anthonyplanet
· 1 		anthonyplanet
Friday, May 25, 2007, 1:06:22 PM
helpful
0
not helpful

I do not think it is to do with the SQL statment as it would have failed for all other users.

You can try using profiler to check the actual statment that is executing and test it in query analyzer.
Mark Wing
· 9108 		Mark Wing
Wednesday, May 30, 2007, 9:55:56 AM
helpful
0
not helpful

i'm gonna give up on the upgrade, i've run out of time. Going to roll back to 2.0.5
will try in a few month when no so manic. sorry not sure how to close ticket.


anthonyplanet
· 1 		anthonyplanet
Monday, June 4, 2007, 1:21:25 PM
helpful
0
not helpful

Thanks for the update.
Mark Wing
· 9108 		Mark Wing
Monday, June 4, 2007, 3:40:53 PM
helpful
0
not helpful

did you get any solution for this problem?

I have the exact same error, and I cannot find much information about how to setup the database, just run some scripts, but:

How to create the actual database?, any specific information like collation needed?
How to set up an database user?, what roles and rights does it need?

I refuse to use the SA account for applications, so how to get this in order woudl be nice.
asbjorn
· 1 		asbjorn
Wednesday, July 4, 2007, 4:13:05 PM
helpful
0
not helpful

Did some things, gave the user dbowner, nothing happened. Gave the user dbdatareader, nothing happened..
Restarted the web, nothing happened.. but recycled the application pool, then it came through.

Which of wich is the solutions remains to see..
asbjorn
· 1 		asbjorn
Wednesday, July 4, 2007, 5:03:30 PM