Current Account

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Current Account

Rate Topic

Display Mode

Topic Options

Author

Message

baburao

Posted 10/30/2006 10:13:01 AM

Forum Newbie

Group: Forum Members
Last Login: 10/31/2006 10:54:00 PM
Posts: 1, Visits: 1

a) How would you see the details of the current Account?

b) What is the correct syntax of the Account function?

babu

Post #5686

GogulM

Posted 10/31/2006 6:01:14 AM

Forum Member

Group: Forum Members
Last Login: 4/30/2008 4:36:46 AM
Posts: 32, Visits: 14

a)sel * from DBC.AccountInfo
where accountname = account..(this will give all accounts for database,users and profile)
if u want more details abt the account.....then
sel * from dbc.dbase
where accountname = account (this will give the default account for each database and the user)

b) sel account;

Regards,

GogulM

Post #5706

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 7:35pm