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: Oracle-DB permissons for System Architect Catalogs
Topic Summary:
Created On: 24-Apr-2006 10:14
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.
 24-Apr-2006 10:14
User is offline View Users Profile Print this message


Stefan Conrad

Posts: 3
Joined: 11-Oct-2005

We actually set up System Architect v10.3 on Oracle. We have some trouble with permissions on creation of catalog-manager. Telelogic support told us, we need a database admin to create a catalog on Oracle-DB, our database department told us, we do not get a dba-user on a productive db-server. Due to the fact, telelogic was not able to extract the create-script form the catalog-manager, they gave us a reproduction of the schema-elements the catalog-manager creates for a new catalog. Our db-admin has created the catalog with these information manually on Database-Level. Now we have a Catalog on the server, but we are not able to access it. Every db-user (even the technical user 'system') get the information 'There is no catalog on Server , that you have permissions to access'. If we try to create a new Catalog on the server, we get the message 'There already exists a catalog'. Has anyone experience with permissions needed to create/access a Catalog on Oracle? What permissions are needed to create Encyclopedias within a Catalog - the Installation Guide lists a number of rights, are these rights sufficent? Best Regard, Stefan Conrad
Report this to a Moderator Report this to a Moderator
 7-Nov-2006 18:05
User is offline View Users Profile Print this message


Marilyne Goudreau

Posts: 1
Joined: 3-Nov-2006

Hi Stefan,

We're having similar problems. How did you resolve yours?

Cheers!
Report this to a Moderator Report this to a Moderator
 8-Nov-2006 10:53
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

You need a user registered in the catalog.
Add these 2 Rows to the Catalog Database. Where DOMAIN - is your network domain, and username is the network username.
The AuditID is arbitrary.

'User' table :-

UserID = 1000
UserName = DOMAIN\username
AuditID = admin
IsGroup = 0
UserDesc = <NULL>


'CatalogPermission' table :-
UserID = 1000
PermissionID = CATALOG
PermissionType = 5
PermissionValue = 15


When you open the catalog, you will need to restore defaults, to put the permissions back in and also the 'Everyone' user.

If this does not work your schema may be incorrect. Please can you add the schema you are using to this topic if problems persist.

Thanks
Ian



-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 0 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 0 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.