user access to the database

Posted in 2004

KENNETH PENZA — Tue, 17 Aug 2004 13:04:08 — source: IIUG Forums & Mailing Lists

People, I have a question regarding database security. Is there a way with I can specify user access using the hostname, like in the case of mysql. For example user1@host1 has select, update, insert and delete on all tables and user1@host20 has select only on all tables

↪ replying to KENNETH PENZA

ART KAGEL, BLOOMBERG/ 499 PARK — Tue, 17 Aug 2004 14:31:35 — source: IIUG Forums & Mailing Lists

No. You can restrict the hosts a user can connect from using the .rhosts file in the user's home directory on the server, but the user's privileges would be the same regardless of host. Art S. Kagel ----- Original Message ----- From: Kenneth Penza <kenneth.penza@gov.mt> At: 8/17 10:10 > People, > > I have a question regarding database security. Is there a way with I can > specify user access using the hostname, like in the case of mysql. > > For example > user1@host1 has select, update, insert and delete on all tables > and > user1@host20 has select only on all tables