Grant SELECT access to user

[Mag0007]

I have a UNIX system id 'foo'

and I would like to give 'foo' SELECT access to a Database Instance 'inst1'

How do I do that?

TIA

 

[gregsimpson]

Mag0007,

you need to do grant select access table by table.

eg

GRANT SELECT ON EMPLOYEE TO USER foo

You may also have to do a

GRANT CONNECT ON DATABASE TO foo

I don't know if you implicitly get connect because you can select. I was told this was the case but it proved to be untrue at my site.

Cheers
Greg

 

[Mag0007]

Great! Thanks.

Looks like that works. I am trying to be secure as possible.

Now the USER = UnixAccount, and it seems to work. I guess thats cool
or is that bad?