cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

Error 15405: Cannot use the reserved user or role name 'dbo'

maj_rif
Level 4

‎08-04-2009 11:52 PM

Hi,
I am trying to update the EV from 7.5 to 8.0 SP2. As per requirement I am trying to assign the following additional rights in the SQL server
  • db_securityadmin
  • db_ddladmin
  • db_datareader
  • db_datawriter
While enabling that rights in SQL 2000 SP4 I am getting error message Error 15405: Cannot use the reserved user or role name 'dbo'

Any one of you can assist me in this regards. I know that this issue is belongs to the SQL Server. Symantec has shared the procedure to create the role for the for the SQL 2005. Any one of you can share the same for SQL 2000 SP4.

Regards/Majrif.
0 Kudos
3 REPLIES 3

Olivian_Retezan
Level 4

‎08-05-2009 01:45 AM

Try to name the role otherwise.

E.g. "EnterriseValutAccess" or "EVAccess".
0 Kudos

maj_rif
Level 4

‎08-05-2009 02:23 AM

how can i create a role in SQL 2000.
0 Kudos

Olivian_Retezan
Level 4

‎08-05-2009 03:05 AM

Check the following article:
http://articles.techrepublic.com.com/5100-10878_11-1061781.html

It has a section called: "Creating a new database role".

Hope this helps.

0 Kudos