Re: Silly Q. How to add user to database?
>This so silly I'm ashamed to ask it but I've been searching for a week
>for the answer.
Probably just looking in the wrong place... :-)
>I just want to a user to a database and grant select, insert, update,
>delete and connect rights for this user. I've been searching the admin
>guide (and my fresh DBA Survival Guide) with no luck!
DATABASE dbname;
GRANT CONNECT TO user;
GRANT ALL ON tablename TO user;
>Also, I would love to know where a log is kept for currently logged-in
>users and "login" accesses to the database.
You can find a list of logged in users with onstat -u and the sysusers
table should give you some indication of who can do what. Just beware of
the user PUBLIC, which means everyone.
HTH.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com