[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dbintegrator_public_public

Title:	DB Integrator Public Conference
Notice:	Database Integration - today! Kit/Doc info see note 36
Moderator:	BROKE::ABUGOV

Created:	Mon Sep 21 1992
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1171
Total number of notes:	5187

1121.0. "dbi 3.1a and RDB-E-NO_PRIV" by UKVMS3::SHISCOCK (stand and deliver) Mon Feb 03 1997 07:11

    Hi,
     
    What are the steps needed to allow general users access to a database
    via DBI. They can access the database directly and the database
    has DISTRIBTRAN granted.
    I'm using a non-privileged a/c and try to access the sample databases
    
    SQL> attach 'f /type=dbi/dbtype=rdb/dbname=dbi_catalog';
    %SQL-F-ERRATTDEC, Error attaching to database
    /type=dbi/dbtype=rdb/dbname=dbi_ca
    talog
    -RDB-E-NO_PRIV, privilege denied by database facility
    -DBI-F-CAT_ACC_FAIL, Fatal DBI physical database access failure
    -RDB-E-NO_PRIV, privilege denied by database facility
    
    I've tried link proxies, vms remote proxies and access to the dbi_catalog
    database for my non-priv user.
    
    cheers,
    
    Steve
    
    p.s. Sorry Diane I've failed on my very first actual dbi call :-{

T.R	Title	User	Personal Name	Date	Lines
1121.1		UKVMS3::PJACKSON	Oracle UK Rdb Support	`Mon Feb 03 1997 08:34`	6
	> -RDB-E-NO_PRIV, privilege denied by database facility It's an RDB error so you need to look at the protection within the Rdb database. Peter
1121.2	SQL GRANT commands needed here...	BROKE::BASTINE		`Mon Feb 03 1997 08:46`	8
	> What are the steps needed to allow general users access to a database > via DBI. They can access the database directly and the database > has DISTRIBTRAN granted. It appears they can't get to the DBI catalog, not the underlying databases. Did you GRANT that user access to the catalog? Renee
1121.3	moving the goal posts only	UKVMS3::SHISCOCK	stand and deliver	`Mon Feb 03 1997 09:41`	11
	since doing SQL> attach 'f DBI_CATALOG'; SQL> grant all on database rdb$dbhandle to public with grant option; the non-priv'd user gets -RDB-E-NO_PRIV, privilege denied by database facility -DBI-F-PRIVVIO, Privilege violation encountered for current DBI database user RGUEST what next :-) ?
1121.4	grant privs in dbi mode...	BROKE::ABUGOV		`Mon Feb 03 1997 09:45`	8
	How about having the admin person doing (while attached in DBI mode): grant select on database rdb$dbhandle (or alias aliasname) to RGUEST; or grant to public if (s)he want to give the world access... dan
1121.5	magic	UKVMS3::SHISCOCK	stand and deliver	`Mon Feb 03 1997 10:23`	2
	Thanks Dan that was the magic switch.