What's new in Silver Sash Administrator 1.0.12

Mar 6, 2012
  • Enhancements:
  • Indexes tab added to Materialized view tabs in Administrator.
  • Restore action added to Recycle bin in Administrator.
  • Refresh action added for Materialized view in Administrator.
  • Enable/disable triggers action added for tables in Administrator.
  • Sub option System privilege added to the main option Security in Administrator. For the System privilege, two actions to grant and revoke system privileges from User and Role added.
  • For sub option Package body, two tabs showing dependants and depends on added.
  • For sub option tablespace with option storage, two tabs showing tables and indexes added.
  • Added action to compile dependant objects of table,view,synonym,sequence,procedure,function and package.
  • Added action to compile synonym
  • Added button in Administrator to refresh list of objects. This can be used in case changes are made to the list by tools other than Silver sash and the list needs to be refreshed to the latest.
  • Added tab in option database and sub option database to list sessions
  • Added action in option database and sub option database to compile all invalid objects in the database.
  • Added button named Re-connect on the Administrator main pane. This button can be used to reconnect to a database if the connection has been disconnected in the background.
  • Added button named kill selected session on the user sessions tab of User sub option and sessions tab of Database. By selecting a session and clicking on this button , sessions can be killed.
  • Added action in option schema and sub option table to enable and disable indexes.
  • Bug fixes:
  • Purge action on Recycle bin was not working.
  • Enable/disable constraint and Enable/disable referencing constraints action for table errors when list of tables is filtered by owner.
  • Package was displaying properties tab instead of procedures tab
  • All object had a tab incorrectly named as dependencies which was renamed to depends on to avoid confusion.
  • Sub option Function's properties tab was empty.
  • Sub option Triggers, compile parameter tab was empty.
  • All dependants and depends on tab had logic added to include object type, since incorrect data is retreived in the case of Package and Package body
  • Overflow exception occurs when a column containing numeric value is displayed
  • Filter button for Tablespace and Datafiles gives error after selection
  • Selecting sub options after the connection has been disconnected in the background gives error.

New in Silver Sash Administrator 1.0.10 (Aug 12, 2011)

  • Enhancements:
  • Exit application button is enhanced to perform the following function before exiting the application
  • lose all open tabs (editor,administrator and monitor). If contents are changed in editor, then it is prompted to save or discard the changes before exiting
  • disconnect all connections.
  • If any connection has uncommitted transactions, user is prompted to commit, rollback or cancel the exiting process
  • This way the user does not have to close individual tabs or individual connections
  • Auto commit features are maintained in the preferences . Auto commit check box is removed from the editor.
  • auto commit is disabled by default
  • Disconnecting a connection checks for whether the transactions are commited or not. If not it will prompt for committing or rolling back the transaction
  • Added commit button on editor pane
  • Added rollback button on editor pane
  • New option added in Monitor where user can choose between 4 charts or 1 chart to be displayed
  • 5 New buttons added to editor
  • Select all button. clicking this button selects all the text in the editor
  • go to line button. clicking this button displays a dialog box where you can enter a line number and the cursor will be placed on that line.
  • copy button. clicking this button copies the contents of the editor to the clipboard
  • cut button. clicking this button cuts the contents of the editor and moves it to the clipboard
  • paste button. clicking this button will paste the copied or cut contents to the editor.
  • Stop on error check box added in editor. When executing multiple statements, if the checkbox is checked then when an error occurs in any of the statements, the subsequent statements will not be executed.
  • Bugs fixed:
  • Auto commit check box on the editor was not working. it is removed.
  • Auto commit settings are now solely performed in the preferences.
  • Other connection properties were not taking effect when new connections were made.
  • Drag and drop tables and columns were not ordered.
  • Maximized mode contained execute all,execute selected and explain plan buttons. they should not be there.
  • Hot keys for Copy, Cut and Paste have been changed to the windows standard Ctrl c, Ctrl x and Ctrl v respectively.
  • Identifying multiple sql statements and plsql statements was incorrect resulting in problems
  • Parsing of comments in the sql and plsql statements was flawed.
  • Drop command was not working for tables and materialized view logs and possibly other objects.