Path: utzoo!attcan!uunet!lll-winken!ncis.llnl.gov!helios.ee.lbl.gov!pasteur!ucbvax!decwrl!purdue!haven!vrdxhq!daitc!jkrueger@daitc.daitc.mil
From: jkrueger@daitc.daitc.mil (Jonathan Krueger)
Newsgroups: comp.databases
Subject: Re: UNIX RTI Ingres 5.0 dba question
Keywords: ingres, system tables, dba
Message-ID: <280@daitc.daitc.mil>
Date: 20 Jan 89 07:35:24 GMT
References: <4364@freja.diku.dk>
Sender: jkrueger@daitc.daitc.mil
Reply-To: jkrueger@daitc.daitc.mil (Jonathan Krueger)
Organization: Defense Applied Information Technology Center
Lines: 15
In-reply-to: jesper@freja.diku.dk (Jesper L. Lauritsen)

In article <4364@freja.diku.dk>, jesper@freja (Jesper L. Lauritsen) writes:
>[how to] put permits on the system tables, or to make
>views on them, so an ordinary user can not query the system tables to see
>other users table definitions??

Permits on system tables aren't enough.  They will stop queries on the
system tables but they will not stop the help command from the
terminal monitor.

Cleanest solution: give each user his or her own database.  Make sure
to create it as a private database, or use accessdb to make it private
after creation.

-- Jon
--