Archives of the TeradataForum
Message Posted: Wed, 14 Sep 2005 @ 18:45:41 GMT
| Subj: || || User Setup: SECADMIN vs SYSDBA |
| From: || || Anomy.Anom |
<-- Anonymously Posted: Wednesday, September 14, 2005 14:43 -->
In our system, we have a user called SYSDBA under DBC that owns all non-system databases. It also owns a user called ALL_USERS, and all user
logon ids are defined under ALL_USERS. The Security Manual recommends setting up a user called SECADMIN under DBC to own all user logon ids. Is
it preferable to have SECADMIN under DBC or under SYSDBA? Are there pros and cons of either?