Skip to Main Content

Portuguese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Falha ao Criar Novo Usuário no SQL Developer

Dax GoulartMar 9 2019 — edited Mar 13 2019

Alguém pode me ajudar para resolver o problema abaixo?

Falha ao processar o comando SQL

- Erro a partir da linha : 2 no comando -

CREATE USER "vendas" IDENTIFIED BY "vendas123" 

DEFAULT TABLESPACE "USERS"

TEMPORARY TABLESPACE "TEMP"

Relatório de erros -

ORA-65096: nome de atribuição ou de usuário comum inválido

65096. 00000 -  "invalid common user or role name"

*Cause:    An attempt was made to create a common user or role with a name

           that was not valid for common users or roles.  In addition to

           the usual rules for user and role names, common user and role

           names must start with C## or c## and consist only of ASCII

           characters.

*Action:   Specify a valid common user or role name.

Abaixo o código:

-- USER SQL

CREATE USER "vendas" IDENTIFIED BY "vendas123" 

DEFAULT TABLESPACE "USERS"

TEMPORARY TABLESPACE "TEMP";

-- QUOTAS

-- ROLES

GRANT "CONNECT" TO "vendas" ;

GRANT "RESOURCE" TO "vendas" ;

-- SYSTEM PRIVILEGES

This post has been answered by J.Laurindo Chiappa on Mar 10 2019
Jump to Answer

Comments

Post Details

Added on Mar 9 2019
5 comments
7,537 views