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.




delete system log

desktop
add-ons

Hi,

which permission is required to delete the system log?

I'm the global administrator an can not delete the log. The following error is added to the log:

User does not have permission to perform this operation on table 'gemini_errorlog'.

--
Kind regards,
Mathias
tolot27
· 1 		tolot27
Monday, January 26, 2009, 8:16:14 AM
Replies (5)
helpful
0
not helpful

This seems to be an SQL permission (not Gemini). Make sure that the SQL user used by Gemini has delete rights on the table.
Mark Wing
· 9108 		Mark Wing
Monday, January 26, 2009, 11:09:30 AM
helpful
0
not helpful

Hi,

the permissions are identical to the other tables and I'm logged in as 'sa'.

With the Query Analyser I can do a 'DELETE FROM geminierrorlog WHERE srn = 1' successfully.

Here is the full stack trace:

User does not have permission to perform this operation on table 'geminierrorlog'.26/01/2009 13:39:31 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNon.Net SqlClient Data Provider--
Kind regards,
Mathias
tolot27
· 1 		tolot27
Monday, January 26, 2009, 12:43:07 PM
helpful
0
not helpful

Yes, but what user is used in the web.config file to connect?
Mark Wing
· 9108 		Mark Wing
Monday, January 26, 2009, 1:15:57 PM
helpful
0
not helpful

Also sa. I did check this before I answered.

--
Kind regards,
Mathias
tolot27
· 1 		tolot27
Monday, January 26, 2009, 6:36:14 PM
helpful
0
not helpful

Can you please use SQL profiler to see the statment that is run when you delete?

 
Saar Cohen
· 5000 		Saar Cohen
Tuesday, January 27, 2009, 8:27:09 PM