create table permissions

[bluecjh]

sql server 2005:

if i give:

GRANT CREATE TABLE TO test12
grant insert to test12
grant select to test12

why is user unable to

select job_no into mytbl from dbo.job

user gets
Msg 15247, Level 16, State 4, Line 1
User does not have permission to perform this action.


what other rights are required

thanks...

BlueCJH

 

[bluecjh]

seems this is a user defined data type issue, the column
job_no has a user defined data type...

so how do you grant rights to use user defined data types...
?

BlueCJH

 

[bluecjh]

GRANT REFERENCES ON TYPE::dbo.myinteger to myrole

but how would you grant rights on all user defined data types... can anyone help?

BlueCJH