|
|
Posted by Hugo Kornelis on 10/13/06 21:31
On 11 Oct 2006 17:47:23 -0700, Amber wrote:
> do the following steps:
(snip)
>10:In the schema1 schema I create a table:create table a(a int ,b
>varchar(10));
To create this table in the schema1 schema, you'll have to specify the
schema. If you don't, it will be created in the dbo schema (since you're
connected as amber, who is database owner.
(snip)
>12:Now I use login guxiaobo to log into dabase and issue "select * from
>a",but got a error msg saying guxiaobo has not enough permission to
>select form table a.
After correcting the code in step 10 to ensure that the table is made in
the correct schema, I didn't get an error here.
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|