The tables are created. I'm able to access them as internal, sys, and
system, and the local set are correctly done on WindowsNT. But I do not
understand why the role I created and the user assigned are not able even to
select anything from any table (trying directly from svrmgr command line
console).
Seen something on the owner of the table but I'm bothered, after 3 days on
the subject, I still do not find...
The script does around eight pages, so I put only the part that interest us.
My role and my user does not seem to be correctly configured... database
exist, table exist, user and role exist also has you can see but I have no
way when I connect as user to do anything :'(
"Alan" <alan_at_erols.com> a écrit dans le message de
news:2hk1i2Fdra7uU1_at_uni-berlin.de...
> I don't see any tables being created in your script.
>
>
> "Romain A" <romain.anselin_at_REMOVETHISclub-internet.fr> wrote in message
> news:c92eea$h37$1_at_s1.read.news.oleane.net...
> > Hello all,
> >
> > I'm creating a procedure in order to mount an Oracle 7.3.4 database on
> > NT4 in less than 45 minutes with batch scripts (preparing my
> examinations).
> > I'm a beginner in using Oracle, and I'm discovering the privileges of
the
> > database.
> > The role I created have the right to manipulate the datas (select on all
> > tables ; insert, update, delete, select on PHOTO which has to be
modified
> by
> > the user), and I added the right of CREATE SESSION.
> > But even through that, when I connect to the database with the user
login,
> I
> > cannot do
> > anything (even a select give me the following error).
> > The error number is ORA-00942 - Table or view does not exist
> > Here is the role and user script... comments are in french sorry
> >
> > /*
> > Script de gestion des droits utilisateurs.
> > On crie ici un rtle UPDFOTO, auquel on attribue les droits de lecture
sur
> > les tables
> > de la base PHOTO, et d'icriture sur la table Photo
> > On crie l'utilisateur ROMAIN. On lui difinit ensuite un mot de passe
> > */
> > connect internal/****** as SYSDBA
> > -- Suppression des rtles et utilisateurs existants
> > DROP ROLE UPDFOTO;
> > DROP USER romain;
> > -- Creation du rtle et de l'utilisateur
> > CREATE ROLE UPDFOTO;
> > CREATE USER romain
> > IDENTIFIED BY anselin
> > DEFAULT TABLESPACE foto_user_data
> > TEMPORARY TABLESPACE foto_temporary_data;
> > -- Attribution des droits au rtle
> > GRANT CREATE SESSION TO UPDFOTO;
> > GRANT SELECT ON MARQUE TO UPDFOTO;
> > GRANT SELECT ON GAMME TO UPDFOTO;
> > GRANT SELECT ON SERIE TO UPDFOTO;
> > GRANT SELECT ON MODELE TO UPDFOTO;
> > GRANT SELECT ON VEHICULE TO UPDFOTO;
> > GRANT SELECT, INSERT, UPDATE, DELETE ON PHOTO TO UPDFOTO;
> > -- Insertion de l'utilisateur dans le groupe
> > GRANT UPDFOTO TO romain;
> >
> > -- Here is the result when searching informations on the system.
> >
> > SVRMGR> select * from dba_roles;
> > ROLE PASSWORD
> > ------------------------------ --------
> > CONNECT NO
> > RESOURCE NO
> > DBA NO
> > EXP_FULL_DATABASE NO
> > IMP_FULL_DATABASE NO
> > SNMPAGENT NO
> > UPDFOTO NO
> > 7 lignes sZlectionnZes
> > SVRMGR> select * from dba_role_privs where granted_role = 'UPDFOTO';
> > GRANTEE GRANTED_ROLE ADM DEF
> > ------------------------------ ------------------------------ --- ---
> > ROMAIN UPDFOTO NO YES
> > SYS UPDFOTO YES YES
> > 14 lignes sZlectionnZes
> > SVRMGR> select * from dba_tab_privs where grantee = 'UPDFOTO';
> > GRANTEE OWNER TABLE_NAME
> > GRANTOR
> > PRIVILEGE GRA
>
> ------------------------------ ------------------------------ ------------
> --
> > ---------------- ---------------------------
> > --- ---------------------------------------- ---
> > UPDFOTO SYS VEHICULE
> > SYS
> > SELECT NO
> > UPDFOTO SYS MARQUE
> > SYS
> > SELECT NO
> > UPDFOTO SYS GAMME
> > SYS
> > SELECT NO
> > UPDFOTO SYS SERIE
> > SYS
> > SELECT NO
> > UPDFOTO SYS MODELE
> > SYS
> > SELECT NO
> > UPDFOTO SYS PHOTO
> > SYS
> > DELETE NO
> > UPDFOTO SYS PHOTO
> > SYS
> > INSERT NO
> > UPDFOTO SYS PHOTO
> > SYS
> > SELECT NO
> > UPDFOTO SYS PHOTO
> > SYS
> > UPDATE NO
> >
> >
> >
> >
>
>
Received on Wed May 26 2004 - 15:30:06 CDT
