- 论坛徽章:
- 1
|
[sybase@server ~]$ isql -Usa -SLOCALHOST
Password:
1> use ceshi
2> go
1> select "grant all on " + name+"to zhang" from sysobjects where type = 'U'
2> go
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
grant all on nihaoto zhang
(1 row affected)
1> exit
[sybase@server ~]$ isql -Uzhang -P123456 -SLOCALHOST
1> select db_name()
2> go
------------------------------------------------------------
ceshi
(1 row affected)
1> select name from sysobjects where type='U'
2> go
name
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
nihao
(1 row affected)
1> select * from nihao
2> go
Msg 10330, Level 14, State 1:
Server 'LOCALHOST', Line 1:
SELECT permission denied on object nihao, database ceshi, owner dbo
回复 5# mission_g
|
|