Skip to content

Instantly share code, notes, and snippets.

@jgoodie

jgoodie/teradata_sql_user_notes.sql

Created December 9, 2022 02:47
Show Gist options
  • Save jgoodie/f4181f399630d3098d4134ec72e5b7d4 to your computer and use it in GitHub Desktop.
Save jgoodie/f4181f399630d3098d4134ec72e5b7d4 to your computer and use it in GitHub Desktop.
Download ZIP
basic user related notes for teradata
Raw
teradata_sql_user_notes.sql
MODIFY user dbc as PASSWORD = new_password;
CREATE USER SYSDBA FROM DBC AS PERM=23592E8, SPOOL=11800E8, TEMPORARY=0, PASSWORD=secret;
GRANT SELECT,EXECUTE ON DBC TO SYSDBA WITH GRANT OPTION;
GRANT ALL ON SYSDBA TO SYSDBA WITH GRANT OPTION;
GRANT SELECT ON SYS_CALENDAR TO SYSDBA WITH GRANT OPTION;
GRANT SELECT ON DBC TO PUBLIC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment