Thursday, January 20, 2011

What's the difference between a database and a user?

Remember either a database or a user can own space

Unlike other database products, Teradata sees little difference between a user and a database. Both need space to contain or own data. In fact, the only real difference is that a user has a password and he or she can log-on and submit SQL requests.

Both a database and a user can own perm space; therefore both can actually own tables.

No comments:

Post a Comment