Tagged Questions

0
votes
1answer
62 views

Oracle- Can't access objects from other users schema

I have an oracle database with 2 users. I have created a table in one of the user accounts, but cannot access the table from the other account ("table or view does not exist"). It doesn't work when I ...
0
votes
2answers
34 views

using multiple schemes in a clustered sql server 2008 Database

I have a SQL server 2008 R2 database with 2 schemas, i need to enhance the performance of the server so we plan to cluster the DB, we will have 2 nodes . is it possible to separate each scheme so each ...
3
votes
2answers
227 views

SQL Server: explicit rights to schema?

When giving permissions to certain Schema in SQL Server, I want to deny some operations from certain users. Do I have to explicitly deny these, or is it so that when user gets a permission to this ...