Skip to Main Content

Portuguese

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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
6,277 views