"what's the point/sense of creating an alone database (without any user) if it cannot log on to the system?"
Only a user can create a database, therefore all databases have an associated user.
Access to a database and it's tables can then be granted to other users.
Rglass
I think you will come to know the difference when you implement the scenarios like temporary, volatile tables and querying and you can check your space allocated.
You can refer to this link too
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/Database_Management/B035_1100_112A/Creating_Users_Granting_Access_Privileges.102.15.html
eg
CREATE DATABASE def FROM abc AS
PERM=...
SPOOL=...
TEMPORARY=...
NO BEFORE JOURNAL
NO AFTER JOURNAL
....
CREATE USER ghi FROM kkk AS
PASSWORD=kkkkk
PERM=0
SPOOL=0
TEMPORARY=0
....
Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.
Hi to all,
I'm not a teradata expert and I have a doubt. Can anyone of you help me?
From official documentation I read the following definition:
"A database and a user are almost identical in Teradata Database. The major difference is that a user can log on to the system whereas the database cannot."
My doubt is: what's the point/sense of creating an alone database (without any user) if it cannot log on to the system?
So, in the above definition it is understood that to any database has associated at least one user and viceversa!!
Is it right?
thanks.