On Wed, Feb 25, 2004 at 10:30:46PM +0530, H S Rai wrote: > I like to know what is needed to work on a default installation on > RedHat8. Does root need to do some thing before normal user can start > working. Is there some default user or database created.
Here goes... The Redhat installation has one user Postgres who can create databases and users. So, the first thing to do is to add yourself as a DB user. To do this, become the postgres user and run the createuser command and follow the prompts. su - postgres createuser username If you answered "yes" to the question whether the new user is allowed to create databases and other users, then you can continue to work as that user. Else, you will need a database created as postgres user. su - postgres createdb testdb Now you add tables, sequences, indexes, views, functions, whatnots to the testdb. Add more users and grant them permissions too. psql> grant select on some_table to user; Binand -- [EMAIL PROTECTED] root]# uptime 11:55am up 58 days, 4:49, 2 users, load average: 1023.78, 419.92, 158.90 ------------------------------------------------------- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
