How we can find total number of max_connection per user in SYBASE IQ 15.X

[Former Member]

Dear All,

Please help me on this topic .

How we can find total number of max_connection per user in SYBASE IQ 15.X

according to me

select * from sa_get_user_status() where user_name like '%user_id%'

this shows the total number of current logins (in connections COLUMN).

i want to get  max connections per user_id

Hoping revert from you all  .

Regards

abhishek

[markmumy]

I am not sure of the question...  A connection is a login from our perspective.

Our login policy has a MAX_CONNECTIONS policy where you can set it to 0 (unlimited) or higher.  This is managed at each node in the logical server.

Are you looking for a way to determine yourself how many connections a user has?  Or are you looking to track this over time?

Mark

[Former Member]

Hi mark,

select * from sa_get_user_status() where user_name like '%xyz%'

here i get connections(column) is 0 ---> means unlimited

now i create a policy

create login policy conn_number MAX_CONNECTIONS = 10

then i add xyz user in conn_number login policy (using alter)

now my question is

how can i find that this user(xyz) has max_connections is 10

i want this SQL query

regards

abhishek

[markmumy]

Oh sure.  Makes sense.  Here's a quick script that I used to illustrate how to capture the data:

create login policy test max_connections = 10

go

create user mark identified by password login policy test

go

select * from sysloginpolicyoption where login_policy_id in

        (

        select login_policy_id from sysuser

        where user_name = 'mark'

        )

login_policy_id login_option_name login_option_value

--------------- ----------------- ----------

4586            max_connections   10

(1 row affected)

In the above case, I created the policy and specified the max_connections property.  If you do not specify the property then all values are default.  That is why you see just one row in the output.  I only overrode the default for max_connections.

Mark

[Former Member]

Hi Marks,

          Thanks a lot for your quick revert ,finally i got which i want ..

abhishek