Adding a database user
A user new to Informix asked how to create a database user with read/write access, unsure whether to grant DBA, RESOURCE or CONNECT. Jack Parker explained the levels: DBA is full admin, RESOURCE allows creating objects (tables, indexes), and CONNECT just permits connecting, after which the user inherits PUBLIC's rights. The recommended approach: GRANT CONNECT TO <user>, then GRANT SELECT/UPDATE/INSERT/DELETE ON <table> TO <user>, adding AS <owner> if the granting user doesn't own the table. The rest of the thread is banter about the acronym TFM (The Fine Manual).
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Up until now, I have been concentrating on the admin side.
I need to make a new user that has read/write for a database. Is that possible
with Informix? From what I reading, I can see that you make a user have DBA,
RESOURCE Or CONNECT.
I think I need my user to have connect.
Can someone confirm this and give me the command to make this in dbaccess?
DBA is full admin rights.
Resource allows them to create objects (tables, indexes)
Connect is they can connect.
Once they are connected, they have all the rights that public has. Or you can
grant them specific rights to specific objects.
So start with:
grant connect to <user>;
grant select on <table> to <user> [as owner]; (if the admin does not own the
table, you might need the as owner - where owner is the table owner)
or - more succintly
grant update, insert, delete on <table> to <user>;
Theres much more to this topic. TFM is your friend.
cheers
j.
> On Mar 6, 2018, at 11:51 AM, BENJI LONG <ruggedmouse@hotmail.com> wrote:
>
> Up until now, I have been concentrating on the admin side.
>
> I need to make a new user that has read/write for a database. Is that
possible
> with Informix? From what I reading, I can see that you make a user have DBA,
> RESOURCE Or CONNECT.
>
> I think I need my user to have connect.
>
> Can someone confirm this and give me the command to make this in dbaccess?
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Thanks very much Jack. I appreciate it.
What is the TFM?
lol. The Fine Manual. j. > On Mar 7, 2018, at 7:36 AM, BENJI LONG <ruggedmouse@hotmail.com> wrote: > > What is the TFM? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Now I feel old. j. > On Mar 7, 2018, at 9:43 AM, Jack Parker <jack.parker4@verizon.net> wrote: > > lol. > > The Fine Manual. > > j. > >> On Mar 7, 2018, at 7:36 AM, BENJI LONG <ruggedmouse@hotmail.com> wrote: >> >> What is the TFM? >> >> >> ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >
We could create some variations around the "F"... but that would also be "old" ;) Regards On Wed, Mar 7, 2018 at 2:45 PM, Jack Parker <jack.parker4@verizon.net> wrote: > Now I feel old. > > j. > > > On Mar 7, 2018, at 9:43 AM, Jack Parker <jack.parker4@verizon.net> > wrote: > > > > lol. > > > > The Fine Manual. > > > > j. > > > >> On Mar 7, 2018, at 7:36 AM, BENJI LONG <ruggedmouse@hotmail.com> wrote: > >> > >> What is the TFM? > >> > >> > >> > ************************************************************ > ******************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > > > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...
The Fine (or other f word) Manual. Usually TFM comes in the form of RTFM - Refer to The Fine Manual. --EEM -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BENJI LONG Sent: Wednesday, March 7, 2018 6:36 AM To: ids@iiug.org Subject: Re: Adding a database user [40801] What is the TFM? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
lol .Ok, yes, I spent a day reading up on security. Going to take a bit to wrap my head around the TFM. A lot to it.