| Hiding tablenames and using synonyms ? [message #36344] |
Mon, 19 November 2001 02:51  |
Jon Donir
Messages: 1
Registered: November 2001
|
Junior Member |
|
|
Is it possible to hide tablenames and only use synonyms for access to tables for all users ?
----------------------------------------------------------------------
|
|
|
|
| Re: Hiding tablenames and using synonyms ? [message #36349 is a reply to message #36344] |
Mon, 19 November 2001 10:38  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
only if your tables and users are in different schemas. It's no big deal and you can control select/indert/update/delete and other privs on each table/proc/function/package etc.
--from scott
grant select on emp to user1;
grant select, update,delete, insert on dept to user1;
--from user1
create synonym emp for scott.emp;
create synonym dept for scott.dept;
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
