Schema Security best practices

Last Post 13 Apr 2009 02:33 PM by ogruizr. 7 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ogruizr
New Member
New Member

--
02 Dec 2008 11:44 AM
Hi all:

I have a server with SQL Server 2005. I created a database named dbsCompany and a schema named Sales. The owner of the schema Sales is the role RoleSales and the user usrSales is member of the role RoleSales.

I want to give all permissions to user usrSales on the Schema Sales. Which permissions do I have to give to usrSales?
ogruizr
New Member
New Member

--
03 Dec 2008 08:15 AM
No, the user usrSales could not to create a table on the schema Sales. (everytime showed access denied)

I fix it when I give it db_owner but I think that it is not the best solution.

ogruizr
New Member
New Member

--
03 Dec 2008 10:09 AM
Anyone of you knows the best practices to work with schemas?
ogruizr
New Member
New Member

--
03 Dec 2008 01:06 PM
The owner of the schema Sales is RoleSales and the user usrSales is member of the role RoleSales. Do you want that usrSales be owner of the schema Sales?
ogruizr
New Member
New Member

--
04 Dec 2008 07:37 AM
What is the best practice?

Is there a document about it?
ogruizr
New Member
New Member

--
13 Apr 2009 10:10 AM
Hi,

I created a schema TEST. The owner of the schema TEST is the user pruebas. Now I try to create a table using the user pruebas:

create table TEST.T1
(c1 varchar(2))

But it shows me the following error:

Msg 262, Level 14, State 1, Line 1
CREATE TABLE permission denied in database 'SOLICITUDESENERGAS'.


Why?
ogruizr
New Member
New Member

--
13 Apr 2009 02:33 PM
I thought that owner is sufficient.
ogruizr
New Member
New Member

--
15 Apr 2009 05:52 AM
Hi all:

Almost all our databases were created using SQL 2000. We migrated to SQL Server 2005 and we want that the next databases created be organized using schemas. Because of that we want to create a procedure and a check list to do that.

Something like:

1. Create a user or Create a Role
2. Create schema
3. The owner of the schema be ...
4.


Where can I find information to do that?
You are not authorized to post a reply.

Acceptable Use Policy