otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire

Go Back   Oracle OTM / G-Log GC3 Community Support > OTM / G-Log - Technical Topics > Security
Reload this Page

[SOLVED] Re-adding the Admin level after it has been removed


Security Keeping your OTM / G-Log instances secure.

Tags: , , ,

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old September 26th, 2007, 12:48
chrisplough's Avatar
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 791
Blog Entries: 7
Thanks: 51
Thanked 194 Times in 119 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to chrisplough
[SOLVED] Re-adding the Admin level after it has been removed

Hello!

Received this one from a friend in the field, after there was a minor accident, resulting in the removal of the Admin Level from an OTM instance. This resulted in every Admin user losing their Admin privileges, so that no one had the rights to re-add it!

In order to resolve, they had to shutdown OTM, log into the OTM DB as glogowner and run the following SQL:
Code:
insert into groupmembers(gm_group, gm_member, gm_type) values ('Administration', 'ADMIN', 'R')
Hope this helps someone in the future! Just remember that OTM doesn't restrict you from doing much -- even self-destructing your instance!

Thanks,
Chris
__________________
Chris Plough
MavenWire

www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding entry in table not reflecting in UI nikesh mohanlal Branding, Screen Sets, XSL/CSS and Translations 2 October 19th, 2007 10:43
[SOLVED] Installation Error: Security Violation: User:'DBA.ADMIN' has insufficient p chrisplough Installation and Upgrades 4 July 5th, 2007 01:53
Adding the fields in the screen sn1405 Branding, Screen Sets, XSL/CSS and Translations 0 June 29th, 2007 11:39
[SOLVED] Issue: Changing GUEST.ADMIN Password Causes OTM Restart to Fail chrisplough Security 0 June 12th, 2007 02:53
v5.5 Upgrade Steps (High-Level) chrisplough Documents and Attachments 0 March 19th, 2007 22:40



All times are GMT. The time now is 09:32.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37