November 28, 2002 at 9:52 am
I explain what I would like to do I would like to be able to créeer an user and that this user can create tables and sights in a data base bd_test and why not to create the data base Being masi I voudrias that it is not the possiblite of utilsier tables to master etc....
At the moment I do this
sp_addlogin test,test
create database bd_test
exec bd_test..sp_adduser test,test
use bd_test
grant create view table to test
Could you me conseigner how I can have a security maximal and how should do also with regard to the user his to put him a password
December 2, 2002 at 8:00 am
This was removed by the editor as SPAM
December 2, 2002 at 10:48 am
Not so clear in the request. Can you explain better what you want? If you want a user to create tables, I'd create a role, give this role the CREATE TABLE right and add a user to this role.
Steve Jones
December 8, 2002 at 3:19 pm
You can assign the user the db_ddladmin role which would let him run any DDL statement to create views, tables, procs, etc. but not actually see any of the data contained in them.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply