All Forums Database
belladikto 11 posts Joined 08/14
04 Oct 2014
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?

Raja_KT 1246 posts Joined 07/09
04 Oct 2014

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_111A/ch06.025.02.html

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.

belladikto 11 posts Joined 08/14
04 Oct 2014

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

 

goldminer 118 posts Joined 05/09
07 Oct 2014

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

You must sign in to leave a comment.