Skip to main content

developerWorks >  Tivoli  >  Forums  >  Maximo  >  developerWorks

Interface table security    Point your RSS reader here for a feed of the latest messages in this thread


     
 
 
My developerWorks
 Welcome, Guest
Sign in or register
Reply to this Thread Reply to this Thread Post New Thread Post New Thread Watch list Watch list Forum settings Forum settings Help Help
Permlink Replies: 3 - Pages: 1 - Last Post: Nov 6, 2009 6:22 AM Last Post By: J@kob Threads: [ Previous | Next ]
bsp

Posts: 10
Registered: Oct 23, 2009 06:39:16 AM
Interface table security
Posted: Nov 06, 2009 01:47:46 AM
Click to report abuse...   Click to reply to this thread Reply
Hi all,

How can I enable security to my interface table for inbound integration? I want to provide only insert access to an external system in order to insert data into my iface table and the queue table. Please help me in figuring this out.

Thanks,
bsp
J@kob

Posts: 39
Registered: Aug 19, 2008 05:17:42 PM
Re: Interface table security
Posted: Nov 06, 2009 03:22:38 AM   in response to: bsp in response to: bsp's post
Click to report abuse...   Click to reply to this thread Reply
You should already have security on your database, so why would you want to have seperate security on specific tables ?

Apart from that, an idea would be to choose a column from your interface table that's not being used, have your external system put a code or password in it ... and create a processing rule to skip entries that don't have that code in it... Still, anyone with access to the database could view the table.
bsp

Posts: 10
Registered: Oct 23, 2009 06:39:16 AM
Re: Interface table security
Posted: Nov 06, 2009 05:56:48 AM   in response to: bsp in response to: bsp's post
Click to report abuse...   Click to reply to this thread Reply
Hi Jacob,

Thanks for the reply. Can you please elaborate on the default database security? In order to allow an external system to write into the maximo interface table or queue table, should I not grant write permissions on those tables? Iam assuming to provide permissions for the external system similar to the user permissions in SQL Server. Is that possible? Please correct me if Iam wrong....

Thanks,
bsp
J@kob

Posts: 39
Registered: Aug 19, 2008 05:17:42 PM
Re: Interface table security
Posted: Nov 06, 2009 06:22:21 AM   in response to: bsp in response to: bsp's post
Click to report abuse...   Click to reply to this thread Reply
With database security I'm refering to usernames/passwords to access the Maximo database, just like the "maximo" account that Maximo itself uses to access the database.
I'm not sure if permissions can be set on specific tables.
Pages: 1
Go Back Back to Thread List
Threads: [ Previous | Next ]

Update your My developerWorks profile and start connecting with others.

Point your RSS reader here for a feed of the latest messages in all forums