×
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

Informix account with read only access!!

Informix account with read only access!!

Informix account with read only access!!

(OP)
Hello,

Please could you help with this..would like to create an Informix account with read only access at the database level. Also set no access for the HR tables along with read only access to the other tables.

Thanks in advance.

Adnan

RE: Informix account with read only access!!

(OP)
PH , Thanks for the response.

I get to know that i have to use the 'grant' command to provide the required access to new user. Please could you suggest, what command or syntax to use to provide read only access to Informix database or tables.
 

RE: Informix account with read only access!!

(OP)
Thanks PH, this is helpful. I am wondering instead of providing tablespace name multiple times, can we provide read access to all the tablespaces in one command. there will be more than 1000 tables. Also please could you confirm this command only provides the read access to tables.

Thanks again.

 

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