×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Index and Priviledges relation

Index and Priviledges relation

Index and Priviledges relation

(OP)
Hi,
I ran SECHECK to fix the "missing index node pointers" problem on one of my informix table. After this problem was fixed, the Select and Update priviledge for all users on this table was revoked. I want to know how are the Indexes and Priviledges on a table related?

RE: Index and Priviledges relation

(OP)
I forgot to mention its Informix SE Standard Engine.

RE: Index and Priviledges relation

I don't use SE so I'm only guessing here:

I do know that when you unload a table and reload it using the "onunload" and "onload" statements the priviledges are revoked and have to be recreated.  Is it possible that to fix the index problem Informix rebuilt the table (or unloaded and reloaded it)?

If so then that's why it happened.  Now the next question is why doesn't Informix recreate the priviledges when it rebuilds the table?  Good question............

Jane

RE: Index and Priviledges relation

(OP)
Jane what I think is that Informix only drops the index and recreates the index. It doesn't meddle with the data.
SO I don't think it did a unload and load.

RE: Index and Priviledges relation

It seems Informix while rebuilding the Index goes into single user mode i.e it won't allow others to select or update the table on which it is recreating the Index. To achieve this Informix might have revoked the access permissions on that table.

G.R.P.

RE: Index and Priviledges relation

(OP)
Even if Informix goes into Single user mode during index recreation, I observed that the related tables are locked exclusively. But there's no reason why the authorities shud be revoked.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close