|
Home > Archive > MS SQL Server > September 2005 > How to disable a user to "Generate SQL Script..."
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to disable a user to "Generate SQL Script..."
|
|
| Joao Rego 2005-09-29, 7:23 am |
| I have an SQLServer 2000 instance with a DataBase.
I have 2 users: sa, new_user.
The [new_user] has membership role: public, db_datareader, db_datawriter
It has permissions to manipulate some table and stored procedures. He can
not export, import, backup, restore the data base.
The point is that he can generate a script for the all database!!!
How do I disable it?
Can some one give me some help on this issue.
Thanks,
| |
| ChrisR 2005-09-29, 1:23 pm |
| Dont allow your users to have Enterprise Manager, much less the Login
information, and the problem will go away.
--
TIA,
ChrisR
"Joao Rego" wrote:
> I have an SQLServer 2000 instance with a DataBase.
> I have 2 users: sa, new_user.
> The [new_user] has membership role: public, db_datareader, db_datawriter
> It has permissions to manipulate some table and stored procedures. He can
> not export, import, backup, restore the data base.
>
> The point is that he can generate a script for the all database!!!
> How do I disable it?
> Can some one give me some help on this issue.
>
> Thanks,
>
| |
| Joao Rego 2005-09-29, 1:23 pm |
| Tks for the tip, but the point is that the user is a freelancer developer
that need to see tables and stored procedures... I just want to protect my
data base from beeing copied.
tks anyway,
Joao
"ChrisR" wrote:
[color=darkred]
> Dont allow your users to have Enterprise Manager, much less the Login
> information, and the problem will go away.
> --
> TIA,
> ChrisR
>
>
> "Joao Rego" wrote:
>
| |
| Jerry Spivey 2005-09-30, 3:23 am |
| Joao,
You've already given the developer the ability to read and write to every
table so. Might want to disallow this and GRANT only the object permissions
that the developer requires to do his job rather than giving the developer
full access to all of the tables.
HTH
Jerry
"Joao Rego" < JoaoRego@discussions
.microsoft.com> wrote in message
news:224ACDD7-DDA2-424D-BA8D- C22A9EDBDE03@microso
ft.com...[color=darkred]
> Tks for the tip, but the point is that the user is a freelancer developer
> that need to see tables and stored procedures... I just want to protect my
> data base from beeing copied.
>
> tks anyway,
> Joao
>
> "ChrisR" wrote:
>
|
|
|
|
|