SQL Server: Access tables in [Cg]

Asked

Viewed 56 times

0

I have a set of tables of "like" Cg in a database, but I can’t access it, it has two types of sets Cg and Dbo, i can access only the tables that are in dbo. Example:

Tables inaccessible guy: Cg

That guy I can’t execute no command, only view and know that the table exists.

Cg.Cliente Cg.Fornecedor Cg.TipoCliente

Tables accessible guy: dbo

In this type I can do any command of the type DML - Data Manipulation Language.

dbo.Telefone dbo.Pedido dbo.Produto

sql database sql-server

  • It is necessary that the user has authorization to access the scheme Cg or any of the tables, individually. It is a matter of safety.

1 answer

0

I recommend that you check the table privileges with the following command:

SELECT GRANTOR, GRANTEE, TABLE_NAME, PRIVILEGE
FROM ALL_TAB_PRIVS
WHERE AND TABLE_NAME = 'nome da tabela';

If you find that you do not have the necessary privileges with your user, if you have permission, of the necessary permissions according to the code below:

GRANT select,update,delete ON 'nome da tabela' TO 'seu usuario';

If you do not have permissions ask for your system’s dba.

Browser other questions tagged sql database sql-server

You are not signed in. Login or sign up in order to post.