Ask Your Question
0

What is the syntax of the GRANT statement in Teradata?

asked 2021-04-15 11:00:00 +0000

devzero gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
3

answered 2021-11-15 08:00:00 +0000

nofretete gravatar image

The syntax of the GRANT statement in Teradata is as follows:

GRANT [privileges] ON [database, user, or object] TO [username or role]

Where, - [privileges] represent the specific rights or permissions that are being granted, such as SELECT, INSERT, UPDATE, DELETE, EXECUTE, CREATE, DROP, INDEX, etc. - [database, user, or object] represents the object or entity on which the privileges are being granted, such as a database, table, view, procedure, macro, user, profile, etc. - [username or role] represents the user or role to whom the privileges are being granted.

Example GRANT SELECT, INSERT, UPDATE ON database1.table1 TO user1;

This statement grants SELECT, INSERT, and UPDATE privileges on the table1 of database1 to user1.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-04-15 11:00:00 +0000

Seen: 8 times

Last updated: Nov 15 '21