Who is responsible for database administration such as permissions?
You are. Each database has a login which is dbo-aliased. By using SQL Enterprise Manager or Transact-SQL and this login, you have full control of your database(s), including the creation of groups, permission allocation, object creation etc. Any option changes not available to the dbo must be submitted to tech support.
- After completing the training on Computer Network Security or Web or Database Administration, Which subject should I pursue in the 4-year university or graduate school?
- Who is responsible for utilization management, including administration of the CAFAS at the local level?
- Who is responsible for database administration such as permissions?