|
Home > Archive > Ingres Database > December 2005 > E_US18AA SET [NO]RULES: You do not have permission ...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
E_US18AA SET [NO]RULES: You do not have permission ...
|
|
| Steve McElhinney 2005-12-08, 5:48 pm |
| Some of our users login to the ingres account (ingres is the DBA of
the database) in order to run scripts and utilities, including ISQL,
using "set norules".
It appears that "set norules" and its trace point qe5,
can only be set by the DBA.
In the short term, we can't change the way the users work,
but is there a way we can allow them to use "set norules" in scripts
and interactively without access the ingres login?
TIA
Steve
| |
| Roy Hann 2005-12-08, 5:48 pm |
| "Steve McElhinney" <stevem@141.com> wrote in message
news:1134058315.199936.160590@g47g2000cwa.googlegroups.com...
> Some of our users login to the ingres account (ingres is the DBA of
> the database) in order to run scripts and utilities, including ISQL,
> using "set norules".
>
> It appears that "set norules" and its trace point qe5,
> can only be set by the DBA.
>
> In the short term, we can't change the way the users work,
> but is there a way we can allow them to use "set norules" in scripts
> and interactively without access the ingres login?
There really isn't a way to grant them just the right to turn off
rule-firing. All you can probably do is grant them the db_admin privilege
on the database in question. That would mean that they wouldn't have to log
in as ingres, but they would still be able to do all the things the owner of
the database is allowed to do. In short, they would still have way too much
power, but at least they'd be confined to the one database.
RTM about :
GRANT db_admin ON DATABASE dbname TO user
Roy Hann (rhann at rationalcommerce dot com)
Rational Commerce Ltd.
www.rationalcommerce.com
"Ingres development, tuning, and training experts"
Ingres Corporation Partner
|
|
|
|
|