Archives of the TeradataForum

Message Posted: Wed, 06 Nov 2002 @ 10:21:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Reddy,

As has been pointed out a user has a password and can therefore login/logon to the DBMS and issue SQL requests. A database does not have a password and therefore cannot logon and issue sql requests.

Just to make it clear, this is the ONLY difference between a user and adatabase.

They can both have space limits, they can both have tables, views, macros etc etc owned by them, you can grant and revoke accessrights to both of them.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

	<Prev	Next>		<<First	<Prev	Next>	Last>>