Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: 10.3 & Oracle install/security
Topic Summary: Making 10.3 & Oracle controllable and secure.
Created On: 25-Apr-2006 12:05
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 25-Apr-2006 12:05
User is offline View Users Profile Print this message


George Brennan

Posts: 7
Joined: 25-Jan-2006

Hi, I thought I'd mention a couple of things with relation to 10.3 & Oracle.

Having installed 10.3/Oracle9i yesterday I am now working through some issues. For security and operational reasons and in no particular order...

we don't want ALL users to have the SAUSER login
we don't want users creating their own ad-hoc encyclopedias
we don't want Sa to have a DBA role.
we don't want the SAUSER name
we don't want SA creating and dropping tablespaces
we don't want to move to Windows security

Current plan in our 10.3 test environment is to
create any new encyclopedia by request ( dba/script )
supply a central UDL file
enable the encyclopedia to login to its encycolpedia without SAUSER.

The SAUSER will change and it's password will not published.

So far so good, catalogue things are next.

Any comments wellcome.


Regards
George.

Edited: 25-Apr-2006 at 12:06 by George Brennan
Report this to a Moderator Report this to a Moderator
 12-May-2006 14:13
User is offline View Users Profile Print this message


Stefan Conrad

Posts: 3
Joined: 11-Oct-2005

Hello George, we tried to set up a Catalogue and got in trouble with exactly the same topics (DBA permissions needed, tablespace has to be created ...). Our hope was, it would be easier to control the users and that they would be able to work with fewer rights, if all encyclopedias and users were created and administrated within the catalogue. We are actually trying to set up the catalogue outside the catalog-manager to avoid these problems, but this isn't easy either! We created a catalogue on SQL-Level (or something we expected to be a catalogue), but we are not able to use it... Best regards, Stefan

Edited: 12-May-2006 at 14:16 by Stefan Conrad
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.