I have just been created as a DBA on a linux server but when I try and run accessdb I get the following error:
E_US18FF User authorization check failed.
Your user identifier was not known to this installation.
Contact your system manager for further assistance.
What needs to be modified so I can run this?
Rich
I have just been created as a DBA on a linux server but when I try and run accessdb I get the following error:
E_US18FF User authorization check failed.
Your user identifier was not known to this installation.
Contact your system manager for further assistance.
What needs to be modified so I can run this?
:
It's important to understand that Ingres distinguishes Ingres system >administrators from Ingres DBAs. A system administrator is responsible
for the Ingres processes and physical resources, and can act as a
security administrator. An Ingres DBA has relatively limited privileges, >being restricted to managing database assets like tables, procedures
etc, and granting access to those assets.
An Ingres DBA is just an ordinary Ingres user who has created a
database and by virtue of doing so is the DBA of that database.
A lot of sites blur/confuse the roles and allow the system administrator >(often the user ingres) to also be the DBA of all the databases. That is
poor practice IMO but very common, possibly almost universal.
If your role is such that you would want to run accessdb that implies to
me that you want to be a system administrator. If you can't/won't su to >ingres to do those things, log in as the installation owner (probably
ingres) then in accessdb "create" your user ID as an Ingres user and
give it the privileges you need, e.g. security administrator, operator, >maintain users, maintain locations--in fact take 'em all.
RoyGeorge
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 418 |
Nodes: | 16 (2 / 14) |
Uptime: | 21:41:44 |
Calls: | 8,764 |
Calls today: | 7 |
Files: | 13,287 |
D/L today: |
3 files (1,633K bytes) |
Messages: | 5,964,648 |