Login and permissions...
When I define a user to connect to my database Informix and I logged with it, I have the message "No connect Permission" What I must do ? Thanks a lot
In the year of Our Lord Thu, 14 Dec 2000 10:07:44 +0100, "JL"
<Jose.LEITE@wanadoo.fr> broke a vow of silence to utter:
>When I define a user to connect to my database Informix and I logged with
>it,
>I have the message "No connect Permission"
>
>What I must do ?
GRANT CONNECT TO user;
-- while logged in as the owner of the database, of course!
RTFM=ON
Thanks for your help, everybody ! It's working... I'm Portuguese and not from "Brasil" and I live in France... Mas falamos a mesma lingua Paulo !!!! Bye Paulo Amorim <pauloamorim@uol.com.br> a 'crit dans le message : 91aecr$j6u$1@nnrp1.deja.com... > In article <91a6kb$j35$1@wanadoo.fr>, > "JL" <Jose.LEITE@wanadoo.fr> wrote: > > Paulo Roberto Marelli de Amorim > TS&0 Consulting > Brasil
JL wrote:
>
> When I define a user to connect to my database Informix and I logged with
> it,
> I have the message "No connect Permission"
>
> What I must do ?
>
GRANT CONNECT TO user;
INSERT INTO brain
SELECT * from manual
WHERE
obvious = "TRUE"
OR
question in
(
SELECT question
FROM questions
WHERE answer = "RTFM"
);
> Thanks a lot
Welcome :-).
In article <91a6kb$j35$1@wanadoo.fr>,
"JL" <Jose.LEITE@wanadoo.fr> wrote:
> When I define a user to connect to my database Informix and I logged
with
> it,
> I have the message "No connect Permission"
>
> What I must do ?
>
> Thanks a lot
>
>
Creating the user in the OS level isn't enough.
You have to grant permission to access your databases. You can do that
in 3 distinct ways:
connect - You allow users to connect to the database, but he can't
alter table structures or create tables. All he can do is access data.
resource - Users can create their own tables, and alter table
structures that have been created by them.
dba - This status allows users to do anything in the database,
including objects created by other users (alter, drop, etc).
The SQL grant command is:
GRANT <level> TO <user> [AS <user>]
Inside your database, there are still different levels to data access.
You can restrict user actions to table level (select, update, delete,
insert, alter, index) using the same syntax, like these:
GRANT update ON <table> to <user> [AS <user>]
GRANT select,insert,delete,update ON <table> to <user>
The clause AS is used to grant permission in the name of another user
(this user must be owner of the database or the object being referred).
Every GRANT command only can be given by the user who owns the object.
The command to revoke the permissions is:
REVOKE <permission> from <user>
Hope this helps.
By the way, are you from Brasil too ???
--
Paulo Roberto Marelli de Amorim
TS&0 Consulting
Brasil
Sent via Deja.com
http://www.deja.com/