ROLES, PRIVILEGES

From: keso <keso_at_hep.tel.fer.hr>
Date: Mon, 25 Oct 1999 17:46:41 +0200
Message-ID: <7v1tna$cls$1@bagan.srce.hr>

DBA's, here's one question that should be easy for you:

What roles & privileges shuld be granted to user that can look but not modify all objects (procedure code, table definition and data etc.) that are in another (specific or all) shema(s)?
So, to put it briefly, what roles/privileges should be granted to make: 1) specific user can look all schema's objects (but not modify) 2) specific user can look specific schema's objects (but not modify)

thanks in advance,

Vedran Received on Mon Oct 25 1999 - 10:46:41 CDT