[ORACLE] usin grant - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

[ORACLE] usin grant

Author

Topic

deathrone
Starting Member

15 Posts

Posted - 2013-06-06 : 09:12:08

Hello,

Ive got 2 accounts, which are connected to one data base.

1 account: I can select data from table "A" and create temporary tables
2 account: I can select data from table "B"

I wanna compare table A with table B, how to do that ? I've heard bout grant but donno how to use it... I'm tryin it in many ways but does'nt work

trololoolo

mmkrishna1919
Yak Posting Veteran

95 Posts

Posted - 2013-06-06 : 09:32:01

try this?

if u have select permission on both tables

select * from account1.tableA
minus/except
select * from account2.tableB
(both tables should have same number and compatible columns)

select * from account2.tableB
minus/except
select * from account1.tableA

if both of them give empty result sets then both tables are exactly same data.

if u don't have select permission then owner of TableA/TableB
should grant Select permissions to you like

Grant select on account1.tableA to (your username)
Grant select on account2.tableB to (your username)

Thanks..

M.MURALI kRISHNA

deathrone
Starting Member

15 Posts

Posted - 2013-06-06 : 09:51:43

thx, i was lookin for dat "grant" part...

so i'm typin this:

grant select on account1.tab_A to (user)

but there problem occures "the username is invalid... How to check my username ?

trololoolo

mmkrishna1919
Yak Posting Veteran

95 Posts

Posted - 2013-06-06 : 10:17:43

Try this?

select user from dual;
or
Show user

Anyway this is Sql server forum good to post this in Oracle forums..

Thanks...

M.MURALI kRISHNA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources