1 Reply Latest reply on Mar 10, 2019 9:38 PM by J.Laurindo Chiappa

    Falha ao Criar Novo Usuário no SQL Developer

    Dax Goulart

      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