Is it possible to implement control access on the line level usning standard
features?
I had to implement several tables User, groupe, article ..., map users to
groups and articles as well as some Sps in order that users or group of users
acces articles they are allowed to diplay.
I would highly appreciate any help
Thanks
"SalamElias" <eliassal@.online.nospam> wrote in message
news:644C3FAF-8D72-4EF4-847F-82E96B13ADD8@.microsoft.com...
> Is it possible to implement control access on the line level usning
> standard
> features?
> I had to implement several tables User, groupe, article ..., map users to
> groups and articles as well as some Sps in order that users or group of
> users
> acces articles they are allowed to diplay.
> I would highly appreciate any help
> Thanks
>
Not sure what you mean by "line level". If you mean on a per-row level,
then yes it is.
Especially if you use stored procs.
I'd keep a table of users and values. Each row would have a corresponding
value.
Do all DML work through a stored proc. So if you want a user to view data,
the stored proc would look at their credentials and as part of the WHERE
clause would select only rows that meet that set of credentials (plus any
others required for that specific query.)
It's also possible to do this via views if you want.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
|||"SalamElias" <eliassal@.online.nospam> wrote in message
news:644C3FAF-8D72-4EF4-847F-82E96B13ADD8@.microsoft.com...
> Is it possible to implement control access on the line level usning
> standard
> features?
> I had to implement several tables User, groupe, article ..., map users to
> groups and articles as well as some Sps in order that users or group of
> users
> acces articles they are allowed to diplay.
> I would highly appreciate any help
> Thanks
>
I think your question is about row-level security. Use stored procedures and
views to limit the rows that individual users can access.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
Showing posts with label level. Show all posts
Showing posts with label level. Show all posts
Sunday, March 25, 2012
Access controlon line level
Is it possible to implement control access on the line level usning standard
features?
I had to implement several tables User, groupe, article ..., map users to
groups and articles as well as some Sps in order that users or group of users
acces articles they are allowed to diplay.
I would highly appreciate any help
Thanks"SalamElias" <eliassal@.online.nospam> wrote in message
news:644C3FAF-8D72-4EF4-847F-82E96B13ADD8@.microsoft.com...
> Is it possible to implement control access on the line level usning
> standard
> features?
> I had to implement several tables User, groupe, article ..., map users to
> groups and articles as well as some Sps in order that users or group of
> users
> acces articles they are allowed to diplay.
> I would highly appreciate any help
> Thanks
>
Not sure what you mean by "line level". If you mean on a per-row level,
then yes it is.
Especially if you use stored procs.
I'd keep a table of users and values. Each row would have a corresponding
value.
Do all DML work through a stored proc. So if you want a user to view data,
the stored proc would look at their credentials and as part of the WHERE
clause would select only rows that meet that set of credentials (plus any
others required for that specific query.)
It's also possible to do this via views if you want.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||"SalamElias" <eliassal@.online.nospam> wrote in message
news:644C3FAF-8D72-4EF4-847F-82E96B13ADD8@.microsoft.com...
> Is it possible to implement control access on the line level usning
> standard
> features?
> I had to implement several tables User, groupe, article ..., map users to
> groups and articles as well as some Sps in order that users or group of
> users
> acces articles they are allowed to diplay.
> I would highly appreciate any help
> Thanks
>
I think your question is about row-level security. Use stored procedures and
views to limit the rows that individual users can access.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
features?
I had to implement several tables User, groupe, article ..., map users to
groups and articles as well as some Sps in order that users or group of users
acces articles they are allowed to diplay.
I would highly appreciate any help
Thanks"SalamElias" <eliassal@.online.nospam> wrote in message
news:644C3FAF-8D72-4EF4-847F-82E96B13ADD8@.microsoft.com...
> Is it possible to implement control access on the line level usning
> standard
> features?
> I had to implement several tables User, groupe, article ..., map users to
> groups and articles as well as some Sps in order that users or group of
> users
> acces articles they are allowed to diplay.
> I would highly appreciate any help
> Thanks
>
Not sure what you mean by "line level". If you mean on a per-row level,
then yes it is.
Especially if you use stored procs.
I'd keep a table of users and values. Each row would have a corresponding
value.
Do all DML work through a stored proc. So if you want a user to view data,
the stored proc would look at their credentials and as part of the WHERE
clause would select only rows that meet that set of credentials (plus any
others required for that specific query.)
It's also possible to do this via views if you want.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||"SalamElias" <eliassal@.online.nospam> wrote in message
news:644C3FAF-8D72-4EF4-847F-82E96B13ADD8@.microsoft.com...
> Is it possible to implement control access on the line level usning
> standard
> features?
> I had to implement several tables User, groupe, article ..., map users to
> groups and articles as well as some Sps in order that users or group of
> users
> acces articles they are allowed to diplay.
> I would highly appreciate any help
> Thanks
>
I think your question is about row-level security. Use stored procedures and
views to limit the rows that individual users can access.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Access controlon line level
Is it possible to implement control access on the line level usning standard
features?
I had to implement several tables User, groupe, article ..., map users to
groups and articles as well as some Sps in order that users or group of user
s
acces articles they are allowed to diplay.
I would highly appreciate any help
Thanks"SalamElias" <eliassal@.online.nospam> wrote in message
news:644C3FAF-8D72-4EF4-847F-82E96B13ADD8@.microsoft.com...
> Is it possible to implement control access on the line level usning
> standard
> features?
> I had to implement several tables User, groupe, article ..., map users to
> groups and articles as well as some Sps in order that users or group of
> users
> acces articles they are allowed to diplay.
> I would highly appreciate any help
> Thanks
>
Not sure what you mean by "line level". If you mean on a per-row level,
then yes it is.
Especially if you use stored procs.
I'd keep a table of users and values. Each row would have a corresponding
value.
Do all DML work through a stored proc. So if you want a user to view data,
the stored proc would look at their credentials and as part of the WHERE
clause would select only rows that meet that set of credentials (plus any
others required for that specific query.)
It's also possible to do this via views if you want.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||"SalamElias" <eliassal@.online.nospam> wrote in message
news:644C3FAF-8D72-4EF4-847F-82E96B13ADD8@.microsoft.com...
> Is it possible to implement control access on the line level usning
> standard
> features?
> I had to implement several tables User, groupe, article ..., map users to
> groups and articles as well as some Sps in order that users or group of
> users
> acces articles they are allowed to diplay.
> I would highly appreciate any help
> Thanks
>
I think your question is about row-level security. Use stored procedures and
views to limit the rows that individual users can access.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
features?
I had to implement several tables User, groupe, article ..., map users to
groups and articles as well as some Sps in order that users or group of user
s
acces articles they are allowed to diplay.
I would highly appreciate any help
Thanks"SalamElias" <eliassal@.online.nospam> wrote in message
news:644C3FAF-8D72-4EF4-847F-82E96B13ADD8@.microsoft.com...
> Is it possible to implement control access on the line level usning
> standard
> features?
> I had to implement several tables User, groupe, article ..., map users to
> groups and articles as well as some Sps in order that users or group of
> users
> acces articles they are allowed to diplay.
> I would highly appreciate any help
> Thanks
>
Not sure what you mean by "line level". If you mean on a per-row level,
then yes it is.
Especially if you use stored procs.
I'd keep a table of users and values. Each row would have a corresponding
value.
Do all DML work through a stored proc. So if you want a user to view data,
the stored proc would look at their credentials and as part of the WHERE
clause would select only rows that meet that set of credentials (plus any
others required for that specific query.)
It's also possible to do this via views if you want.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||"SalamElias" <eliassal@.online.nospam> wrote in message
news:644C3FAF-8D72-4EF4-847F-82E96B13ADD8@.microsoft.com...
> Is it possible to implement control access on the line level usning
> standard
> features?
> I had to implement several tables User, groupe, article ..., map users to
> groups and articles as well as some Sps in order that users or group of
> users
> acces articles they are allowed to diplay.
> I would highly appreciate any help
> Thanks
>
I think your question is about row-level security. Use stored procedures and
views to limit the rows that individual users can access.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Tuesday, March 6, 2012
About trace flag 8588
Hi Guys,
I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
while the session is enlisted in a distributed transaction that has an active
savepoint. I setup two sql server 2000 in two windows 2003 server, both
install sql server sp1. I created linked server and setup MCDTC on both
server. When I run application that include distributed transaction, I got
error above. I re-check MCDTC, permission and so on, but I still got that
issue. Could some one help me to fix it? Thanks in advance.For more information about using trace flags and startup parameters, see the
"DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
Online.
To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Once you update the service pack your problem will get fixed. Please update
the same and lemme know if it works...
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"Iter" wrote:
> Hi Guys,
> I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
> while the session is enlisted in a distributed transaction that has an active
> savepoint. I setup two sql server 2000 in two windows 2003 server, both
> install sql server sp1. I created linked server and setup MCDTC on both
> server. When I run application that include distributed transaction, I got
> error above. I re-check MCDTC, permission and so on, but I still got that
> issue. Could some one help me to fix it? Thanks in advance.
>|||Thank you very much. But for my case, the server is windows 2003 and have
already installed service pack 1. Is there something else that I need to
install? Thanks.
"Sreejith G" wrote:
> For more information about using trace flags and startup parameters, see the
> "DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
> Online.
> To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
> Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
> Once you update the service pack your problem will get fixed. Please update
> the same and lemme know if it works...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
> "Iter" wrote:
> > Hi Guys,
> > I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
> > while the session is enlisted in a distributed transaction that has an active
> > savepoint. I setup two sql server 2000 in two windows 2003 server, both
> > install sql server sp1. I created linked server and setup MCDTC on both
> > server. When I run application that include distributed transaction, I got
> > error above. I re-check MCDTC, permission and so on, but I still got that
> > issue. Could some one help me to fix it? Thanks in advance.
> >
I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
while the session is enlisted in a distributed transaction that has an active
savepoint. I setup two sql server 2000 in two windows 2003 server, both
install sql server sp1. I created linked server and setup MCDTC on both
server. When I run application that include distributed transaction, I got
error above. I re-check MCDTC, permission and so on, but I still got that
issue. Could some one help me to fix it? Thanks in advance.For more information about using trace flags and startup parameters, see the
"DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
Online.
To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Once you update the service pack your problem will get fixed. Please update
the same and lemme know if it works...
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"Iter" wrote:
> Hi Guys,
> I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
> while the session is enlisted in a distributed transaction that has an active
> savepoint. I setup two sql server 2000 in two windows 2003 server, both
> install sql server sp1. I created linked server and setup MCDTC on both
> server. When I run application that include distributed transaction, I got
> error above. I re-check MCDTC, permission and so on, but I still got that
> issue. Could some one help me to fix it? Thanks in advance.
>|||Thank you very much. But for my case, the server is windows 2003 and have
already installed service pack 1. Is there something else that I need to
install? Thanks.
"Sreejith G" wrote:
> For more information about using trace flags and startup parameters, see the
> "DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
> Online.
> To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
> Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
> Once you update the service pack your problem will get fixed. Please update
> the same and lemme know if it works...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
> "Iter" wrote:
> > Hi Guys,
> > I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
> > while the session is enlisted in a distributed transaction that has an active
> > savepoint. I setup two sql server 2000 in two windows 2003 server, both
> > install sql server sp1. I created linked server and setup MCDTC on both
> > server. When I run application that include distributed transaction, I got
> > error above. I re-check MCDTC, permission and so on, but I still got that
> > issue. Could some one help me to fix it? Thanks in advance.
> >
About trace flag 8588
Hi Guys,
I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
while the session is enlisted in a distributed transaction that has an activ
e
savepoint. I setup two sql server 2000 in two windows 2003 server, both
install sql server sp1. I created linked server and setup MCDTC on both
server. When I run application that include distributed transaction, I got
error above. I re-check MCDTC, permission and so on, but I still got that
issue. Could some one help me to fix it? Thanks in advance.For more information about using trace flags and startup parameters, see the
"DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
Online.
To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Once you update the service pack your problem will get fixed. Please update
the same and lemme know if it works...
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"Iter" wrote:
> Hi Guys,
> I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remot
e
> while the session is enlisted in a distributed transaction that has an act
ive
> savepoint. I setup two sql server 2000 in two windows 2003 server, both
> install sql server sp1. I created linked server and setup MCDTC on both
> server. When I run application that include distributed transaction, I got
> error above. I re-check MCDTC, permission and so on, but I still got that
> issue. Could some one help me to fix it? Thanks in advance.
>|||Thank you very much. But for my case, the server is windows 2003 and have
already installed service pack 1. Is there something else that I need to
install? Thanks.
"Sreejith G" wrote:
[vbcol=seagreen]
> For more information about using trace flags and startup parameters, see t
he
> "DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
> Online.
> To use trace flag 8599, obtain the latest service pack for SQL Server 2000
:
> Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
> Once you update the service pack your problem will get fixed. Please updat
e
> the same and lemme know if it works...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread an
d time
> asking back if its 2000 or 2005]
>
> "Iter" wrote:
>
I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
while the session is enlisted in a distributed transaction that has an activ
e
savepoint. I setup two sql server 2000 in two windows 2003 server, both
install sql server sp1. I created linked server and setup MCDTC on both
server. When I run application that include distributed transaction, I got
error above. I re-check MCDTC, permission and so on, but I still got that
issue. Could some one help me to fix it? Thanks in advance.For more information about using trace flags and startup parameters, see the
"DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
Online.
To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Once you update the service pack your problem will get fixed. Please update
the same and lemme know if it works...
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"Iter" wrote:
> Hi Guys,
> I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remot
e
> while the session is enlisted in a distributed transaction that has an act
ive
> savepoint. I setup two sql server 2000 in two windows 2003 server, both
> install sql server sp1. I created linked server and setup MCDTC on both
> server. When I run application that include distributed transaction, I got
> error above. I re-check MCDTC, permission and so on, but I still got that
> issue. Could some one help me to fix it? Thanks in advance.
>|||Thank you very much. But for my case, the server is windows 2003 and have
already installed service pack 1. Is there something else that I need to
install? Thanks.
"Sreejith G" wrote:
[vbcol=seagreen]
> For more information about using trace flags and startup parameters, see t
he
> "DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
> Online.
> To use trace flag 8599, obtain the latest service pack for SQL Server 2000
:
> Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
> Once you update the service pack your problem will get fixed. Please updat
e
> the same and lemme know if it works...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread an
d time
> asking back if its 2000 or 2005]
>
> "Iter" wrote:
>
Thursday, February 16, 2012
about messges in microsoft sql express
:eek: :eek: :eek: :eek:
Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'contains'.
Msg 102, Level 15, State 1, Line 8
Incorrect syntax near ')'.
i am getting error messages like this.
I want to know what this message really
mean i.e list of messages corresponding to numbers......The SQL engine uses only the error numbers internally. Those are what the engine know about, and are how it complains about "bad code" that it receives from the SQL client. The error message displayed below the Msg line contains a description of the error in the current locale (in this case, essentially a human language like English, Spanish, French, etc).
The process of getting the text description is simply a table lookup, there's no "magic" associated with it. The table of error messages changes constantly, usually with every service pack.
-PatP|||they are stored in sysmessages:
select * from sysmessages where error in (102,156)
Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'contains'.
Msg 102, Level 15, State 1, Line 8
Incorrect syntax near ')'.
i am getting error messages like this.
I want to know what this message really
mean i.e list of messages corresponding to numbers......The SQL engine uses only the error numbers internally. Those are what the engine know about, and are how it complains about "bad code" that it receives from the SQL client. The error message displayed below the Msg line contains a description of the error in the current locale (in this case, essentially a human language like English, Spanish, French, etc).
The process of getting the text description is simply a table lookup, there's no "magic" associated with it. The table of error messages changes constantly, usually with every service pack.
-PatP|||they are stored in sysmessages:
select * from sysmessages where error in (102,156)
Subscribe to:
Posts (Atom)