[Doubt] Access only consultation and ODBC

[dcvitoria]

Environment information:
* Oracle version: Oracle Xe
* Operating system: Windows 2003 Server

Good morning.

First time I move with Oracle, and I'm really enjoying it, but I have a problem.

I would like to create a user only in Oracle, so I could, via ODBC, link some tables without the possibility of editing them. I'vê done everything, I went through Oracle's "User Creator", I went by SQL Giving Grant, I tried to limit the ODBC by marking the option of only query and at the time of binding an error. If I give DBA access, everything comes normally, but the tables are editable.

Who can help me, I thank you from now!

PS: Until today I only moved with MSSQL, I have some knowledge about the SQL language, but I know little yet from the Oracle interface, I'm going to "Deduzometer".

Thanks

Dino

[gilbertoca]

Normally, there is a combination of 1 = 1 between user and object schema, that is, a user is owner / owner of objects created by it and if another user need to use these objects, the owner user grants certain privileges (Grant).

To facilitate clusters certain objects for certain users. Create a paper (role) with the permissions that you want your users to have, then grant access to these objects through that paper (role).
[url=http://download.oracle.com/docs/cd/B193 ... SQLRF01311]CREATE ROLE

Gilberto

[dcvitoria]

Right Gilberto, the problem is that if I give DBA access and create roles for it, will it work? Here gave error when trying to put roles in a dba user ...

[gilbertoca]

Never give DBA privilege for user! The problem that can occur in access is precisely the lack of a paper assignment required for creating the user's session.

Show us the error.

[dcvitoria]

Once again, thank you for helping me, really!

The ODBC error:

Select all

[Oracle][ODBC][Ora]ORA-01017:invalid username/password; logon denied 
(#1017)[Microsoft][ODBC Driver Manager] Falha de SQLSetConnectAttr do driver (#0) [Microsoft][ODBC Driver Manager] Falha de SQLSetConnectAttr do driver (#0)

As the user is configured:

Object PTIVILEGES tab:
Object: Users
Only the SELECT guide with Yes

Guide Role privileges:
Scroll: Connect Marked Default
Scroll: Default Marked Resource
System privilegies:
Unlimited tablespace
Quota
Tablespace: Users
Unlimited True [99]

Thanks!

[gilbertoca]

Are two correct machines? A server and a client, am I right?

Install the Oracle client on this machine (client) and try access through SQLPlus. Or rather, install SQLDeveloper and test with that user.

Gilberto

[dcvitoria]

Gilberto, sorry, but this part would be very difficult for me (heheh), run away from my knowledge
but thanks for the help!

[dcvitoria]

By SQL Plus, I was able to do it. The user without DBA can read normal as well as the DBA user.

The problem still continues in ODBC ..... I can not make a user, see only, read my ODBC ...

[gilbertoca]

The problem still continues in ODBC ..... I can not make a user, only query, read my ODBC ... [/quote]

When installing the client, choose Customize and beyond From the defaults items, select the Extensions / Supplements for your API (A Used to develop the application), for example, ODBC Supplement.
[url=http://www.oracle.com/technology/tech/o ... index.html]Oracle Database Instant Client

Gilberto