Create a SUPER/DBA/POWER User

Database
Enthusiast

Create a SUPER/DBA/POWER User

hello, I need to give a user the same privileges dbc user.

for example:

create-drop view, create-drop table, insert, delete, and etc.... in all databases and tables

as I can do?

3 REPLIES
Enthusiast

Re: Create a SUPER/DBA/POWER User

Why so?

If everything is the same, then I feel it is better to share the password, because maintanance is less. If not then grant roles, profiles....

You can go thru this link:

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1093_111...

Enthusiast

Re: Create a SUPER/DBA/POWER User

need a user with the same privileges as the DBC, since misuse DBC blockade was due to pay a large sum of money for the release of dbc.

therefore it is necessary to give the same privileges and the server has many bases to do it manually,

thank you



Enthusiast

Re: Create a SUPER/DBA/POWER User

Does the user really need/want DBC access rights?  Most I talk to would not want this type of access due to the damage they could accidently do.  I would never give a user DBC rights under any circumstances.  There are other ways to give them the rights that they need without granting DBC.

Joe