Home » SQL & PL/SQL » SQL & PL/SQL » Hiding tablenames and using synonyms ?
Hiding tablenames and using synonyms ? [message #36344] Mon, 19 November 2001 02:51 Go to next message
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 Go to previous message
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;

----------------------------------------------------------------------
Previous Topic: trigger question
Next Topic: OnConnect/OnDisconnect events?
Goto Forum:
  


Current Time: Fri Mar 29 01:57:25 CDT 2024